Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ora-06553 pls-306 wrong number or types of arguments in call to 'ogc_x'

user9093700Oct 20 2016 — edited Oct 20 2016

select * from (select mmt.SUBINVENTORY_CODE Inv_Org,MSI.SEGMENT1 Item_Code, MSI.DESCRIPTION ITEM_DESCRIPTION, MSI.PRIMARY_UOM_CODE UOM, 

sum (mmt.TRANSACTION_QUANTITY) TOT_QTY, (sum (mmt.TRANSACTION_QUANTITY)*((sum(X.AMOUNT)/sum(X.TOT_QTY)))) AMOUNT,

mtt.TRANSACTION_TYPE_ID TRANSACTION_ID

from mtl_material_transactions mmt, MTL_SYSTEM_ITEMS_B MSI, mtl_transaction_types mtt,CM_CMPT_DTL CCD

where mmt.ORGANIZATION_ID in (934)

and mmt.ORGANIZATION_ID=MSI.ORGANIZATION_ID

and mmt.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID

and mmt.INVENTORY_ITEM_ID=CCD.INVENTORY_ITEM_ID

and CCD.PERIOD_ID = 511

and mmt.TRANSACTION_TYPE_ID=mtt.TRANSACTION_TYPE_ID

and mmt.transaction_type_id in (32)

and TRUNC(mmt.TRANSACTION_DATE) between '01/SEP/2016' and '30/SEP/2016'

group by MSI.SEGMENT1, mmt.SUBINVENTORY_CODE, MSI.DESCRIPTION,mtt.TRANSACTION_TYPE_ID,MSI.PRIMARY_UOM_CODE,CCD.CMPNT_COST) P

UNION ALL

select * from (

select * from (select mmt.SUBINVENTORY_CODE Inv_Org,MSI.SEGMENT1 Item_Code, MSI.DESCRIPTION ITEM_DESCRIPTION, MSI.PRIMARY_UOM_CODE UOM, 

sum (mmt.TRANSACTION_QUANTITY) TOT_QTY, (sum (mmt.TRANSACTION_QUANTITY)*CCD.CMPNT_COST) AMOUNT,

mtt.TRANSACTION_TYPE_ID TRANSACTION_ID

from mtl_material_transactions mmt, MTL_SYSTEM_ITEMS_B MSI, mtl_transaction_types mtt,CM_CMPT_DTL CCD

where mmt.ORGANIZATION_ID in (934)

and mmt.ORGANIZATION_ID=MSI.ORGANIZATION_ID

and mmt.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID

and mmt.INVENTORY_ITEM_ID=CCD.INVENTORY_ITEM_ID

and CCD.PERIOD_ID = 511

and mmt.TRANSACTION_TYPE_ID=mtt.TRANSACTION_TYPE_ID

and mmt.transaction_type_id in (42)

and TRUNC(mmt.TRANSACTION_DATE) between '01/SEP/2016' and '30/SEP/2016'

group by MSI.SEGMENT1, mmt.SUBINVENTORY_CODE, MSI.DESCRIPTION,mtt.TRANSACTION_TYPE_ID,MSI.PRIMARY_UOM_CODE,CCD.CMPNT_COST) Q

UNION ALL

SELECT * FROM (select mmt.SUBINVENTORY_CODE Inv_Org,MSI.SEGMENT1 Item_Code, MSI.DESCRIPTION ITEM_DESCRIPTION, MSI.PRIMARY_UOM_CODE UOM, 

sum (mmt.TRANSACTION_QUANTITY) TOT_QTY, (sum (mmt.TRANSACTION_QUANTITY)*MMT.ACTUAL_COST) AMOUNT,

mtt.TRANSACTION_TYPE_ID TRANSACTION_ID

from mtl_material_transactions mmt, MTL_SYSTEM_ITEMS_B MSI, mtl_transaction_types mtt

where mmt.ORGANIZATION_ID in (934)

and mmt.ORGANIZATION_ID=MSI.ORGANIZATION_ID

and mmt.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID

and mmt.TRANSACTION_TYPE_ID=mtt.TRANSACTION_TYPE_ID

and mmt.transaction_type_id in (18)

and TRUNC(mmt.TRANSACTION_DATE) between '01/SEP/2016' and '30/SEP/2016'

group by MSI.SEGMENT1, mmt.SUBINVENTORY_CODE, MSI.DESCRIPTION,mtt.TRANSACTION_TYPE_ID,MSI.PRIMARY_UOM_CODE,MMT.ACTUAL_COST) R

) X

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 17 2016
Added on Oct 20 2016
4 comments
2,645 views