DBA Data[Home] [Help]

APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on ASG_USER_PUB_RESPS

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 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 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 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