DBA Data[Home] [Help]

APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on ASG_USER

Line 207: FROM asg_user au,

203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,
208: asg_user_pub_resps aupr,
209: mtl_system_items_b msi,
210: CS_BILLING_TYPE_CATEGORIES cbtc
211: WHERE au.user_id = p_user_id

Line 208: asg_user_pub_resps aupr,

204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,
208: asg_user_pub_resps aupr,
209: mtl_system_items_b msi,
210: CS_BILLING_TYPE_CATEGORIES cbtc
211: WHERE au.user_id = p_user_id
212: AND au.user_name = aupr.user_name

Line 363: FROM asg_user au,

359: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
360: au.user_id,
361: msi.inventory_item_id,
362: msi.organization_id
363: FROM asg_user au,
364: asg_user_pub_resps aupr,
365: csm_user_inventory_org user_org,
366: mtl_system_items_b msi,
367: CS_BILLING_TYPE_CATEGORIES cbtc

Line 364: asg_user_pub_resps aupr,

360: au.user_id,
361: msi.inventory_item_id,
362: msi.organization_id
363: FROM asg_user au,
364: asg_user_pub_resps aupr,
365: csm_user_inventory_org user_org,
366: mtl_system_items_b msi,
367: CS_BILLING_TYPE_CATEGORIES cbtc
368: WHERE au.user_name = aupr.user_name

Line 407: asg_user au,

403: acc.user_id,
404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,
407: asg_user au,
408: mtl_system_items_tl msi_tl
409: WHERE acc.user_id = au.user_id
410: AND acc.inventory_item_id = msi_tl.inventory_item_id
411: AND acc.organization_id = msi_tl.organization_id

Line 700: FROM asg_user au,

696: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
697: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
698: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
699: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
700: FROM asg_user au,
701: asg_user_pub_resps aupr,
702: mtl_onhand_quantities_detail ohqmv,
703: mtl_system_items_b msi,
704: CS_BILLING_TYPE_CATEGORIES cbtc

Line 701: asg_user_pub_resps aupr,

697: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
698: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
699: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
700: FROM asg_user au,
701: asg_user_pub_resps aupr,
702: mtl_onhand_quantities_detail ohqmv,
703: mtl_system_items_b msi,
704: CS_BILLING_TYPE_CATEGORIES cbtc
705: WHERE au.user_name = aupr.user_name

Line 748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;

744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
750:
751: inv_id inv_idTab;
752: org_id org_idTab;

Line 1011: FROM asg_user au,

1007: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
1008: au.user_id,
1009: msi.inventory_item_id,
1010: msi.organization_id
1011: FROM asg_user au,
1012: asg_user_pub_resps aupr,
1013: mtl_system_items_b msi,
1014: CS_BILLING_TYPE_CATEGORIES cbtc
1015: WHERE au.user_id = p_user_id

Line 1012: asg_user_pub_resps aupr,

1008: au.user_id,
1009: msi.inventory_item_id,
1010: msi.organization_id
1011: FROM asg_user au,
1012: asg_user_pub_resps aupr,
1013: mtl_system_items_b msi,
1014: CS_BILLING_TYPE_CATEGORIES cbtc
1015: WHERE au.user_id = p_user_id
1016: AND au.user_name = aupr.user_name