[Home] [Help]
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
213: AND aupr.pub_name = 'SERVICEP'
214: AND msi.organization_id = p_new_organization_id
367: msi.organization_id
368: FROM asg_user au,
369: csm_user_inventory_org user_org,
370: mtl_system_items_b msi,
371: CS_BILLING_TYPE_CATEGORIES cbtc
372: WHERE user_org.user_id = au.user_id
373: AND au.user_id = au.owner_id
374: AND msi.organization_id = user_org.organization_id
375: AND msi.enabled_flag = 'Y'
388: IS
389: SELECT msi.inventory_item_id,
390: msi.organization_id
391: FROM mtl_system_items_b msi,
392: CS_BILLING_TYPE_CATEGORIES cbtc
393: WHERE msi.organization_id = p_user_organization_id
394: AND msi.enabled_flag = 'Y'
395: AND SYSDATE BETWEEN nvl(msi.start_date_active, SYSDATE) AND nvl(msi.end_date_active, SYSDATE)
396: AND msi.material_billable_flag = cbtc.billing_type
440: FROM csm_system_items_acc acc
441: WHERE NOT EXISTS
442: (SELECT 1
443: FROM mtl_system_items_b msi,
444: CS_BILLING_TYPE_CATEGORIES cbtc
445: WHERE msi.inventory_item_id = acc.inventory_item_id
446: AND msi.organization_id = acc.organization_id
447: AND msi.material_billable_flag = cbtc.billing_type
448: AND cbtc.billing_category IN ('L', 'E')
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
795: AND aupr.pub_name = 'SERVICEP'
796: AND au.user_id = au.owner_id
797: AND msi.INVENTORY_ITEM_ID = ohqmv.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
1141: AND aupr.pub_name = 'SERVICEP'
1142: AND msi.organization_id = p_organization_id