APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSF_DEBRIEF_LINES

Line 1165: from csf_debrief_lines b

1161: from csm_mtl_system_items_acc a,asg_user au
1162: where au.user_id=a.user_id
1163: and NVL(au.MULTI_PLATFORM,'N')='Y'
1164: and not exists (select 1
1165: from csf_debrief_lines b
1166: where transaction_type_id in (select transaction_type_id
1167: from cs_transaction_types_b
1168: where line_order_category_code='RETURN')
1169: and b.last_update_date >= b_ret_acty_date

Line 1197: sum(quantity) tot from csf_debrief_lines b

1193: select csm_mtl_system_items_acc_s.NEXTVAL,item_id,msi.org_id,au.user_id
1194: from (select item_id,org_id from
1195: (select inventory_item_id as item_id,
1196: nvl(receiving_inventory_org_id,issuing_inventory_org_id) as org_id,
1197: sum(quantity) tot from csf_debrief_lines b
1198: where transaction_type_id in (select transaction_type_id
1199: from cs_transaction_types_b
1200: where line_order_category_code='RETURN')
1201: and inventory_item_id is not null