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 790: asg_user_pub_resps aupr,

786: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
787: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
788: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
789: FROM asg_user au,
790: asg_user_pub_resps aupr,
791: mtl_onhand_quantities_detail ohqmv,
792: mtl_system_items_b msi,
793: CS_BILLING_TYPE_CATEGORIES cbtc
794: WHERE au.user_name = aupr.user_name

Line 1136: asg_user_pub_resps aupr,

1132: au.user_id,
1133: msi.inventory_item_id,
1134: msi.organization_id
1135: FROM asg_user au,
1136: asg_user_pub_resps aupr,
1137: mtl_system_items_b msi,
1138: CS_BILLING_TYPE_CATEGORIES cbtc
1139: WHERE au.user_id = p_user_id
1140: AND au.user_name = aupr.user_name