APPS.OE_PREPAYMENT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 46: FROM mtl_system_items mti

42: AND ool.cancelled_flag = 'N'
43: AND ool.line_category_code <> 'RETURN'
44: AND NOT EXISTS
45: (SELECT 'Non Invoiceable Item Line'
46: FROM mtl_system_items mti
47: WHERE mti.inventory_item_id = ool.inventory_item_id
48: AND mti.organization_id = nvl(ool.ship_from_org_id,
49: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))
50: AND (mti.invoiceable_item_flag = 'N'

Line 61: FROM mtl_system_items mti, oe_order_lines_all ool

57: FROM oe_payments op
58: WHERE op.header_id = p_header_id
59: AND NOT EXISTS
60: (SELECT 'Non Invoiceable Item Line'
61: FROM mtl_system_items mti, oe_order_lines_all ool
62: WHERE ool.line_id = op.line_id
63: AND mti.inventory_item_id = ool.inventory_item_id
64: AND mti.organization_id = nvl(ool.ship_from_org_id,
65: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))

Line 80: FROM mtl_system_items mti

76: AND ool.cancelled_flag = 'N'
77: AND ool.line_category_code <> 'RETURN'
78: AND NOT EXISTS
79: (SELECT 'Non Invoiceable Item Line'
80: FROM mtl_system_items mti
81: WHERE mti.inventory_item_id = ool.inventory_item_id
82: AND mti.organization_id = nvl(ool.ship_from_org_id,
83: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))
84: AND (mti.invoiceable_item_flag = 'N'

Line 128: FROM MTL_SYSTEM_ITEMS MTI

124: AND L.cancelled_flag = 'N'
125: AND L.line_category_code <> 'RETURN'
126: AND NOT EXISTS
127: (SELECT 'Non Invoiceable Item Line'
128: FROM MTL_SYSTEM_ITEMS MTI
129: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
130: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
131: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))
132: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'