APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CS_TRANSACTION_TYPES_B

Line 1167: from cs_transaction_types_b

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
1170: and a.inventory_item_id=b.inventory_item_id
1171: and a.organization_id=nvl(b.receiving_inventory_org_id,b.issuing_inventory_org_id)) --return debrief-ed items

Line 1199: from cs_transaction_types_b

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
1202: and nvl(receiving_inventory_org_id,issuing_inventory_org_id) is not null
1203: and b.lasT_update_date > b_ret_acty_date