APPS.OE_OE_TOTALS_SUMMARY dependencies on MTL_SYSTEM_ITEMS

Line 593: FROM mtl_system_items mti

589: AND ool.line_category_code <> 'RETURN'
590: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
591: AND NOT EXISTS
592: (SELECT 'Non Invoiceable Item Line'
593: FROM mtl_system_items mti
594: WHERE mti.inventory_item_id = ool.inventory_item_id
595: AND mti.organization_id = nvl(ool.ship_from_org_id,
596: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
597: AND (mti.invoiceable_item_flag = 'N'

Line 608: FROM mtl_system_items mti, oe_order_lines_all ool

604: FROM oe_payments op
605: WHERE op.header_id = p_header_id
606: AND NOT EXISTS
607: (SELECT 'Non Invoiceable Item Line'
608: FROM mtl_system_items mti, oe_order_lines_all ool
609: WHERE ool.line_id = op.line_id
610: AND mti.inventory_item_id = ool.inventory_item_id
611: AND mti.organization_id = nvl(ool.ship_from_org_id,
612: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 628: FROM mtl_system_items mti

624: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
625: AND ool.line_category_code <> 'RETURN'
626: AND NOT EXISTS
627: (SELECT 'Non Invoiceable Item Line'
628: FROM mtl_system_items mti
629: WHERE mti.inventory_item_id = ool.inventory_item_id
630: AND mti.organization_id = nvl(ool.ship_from_org_id,
631: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
632: AND (mti.invoiceable_item_flag = 'N'

Line 691: FROM MTL_SYSTEM_ITEMS MTI

687: OR nvl(p_all_lines, 'N') = 'Y' )
688: AND L.line_category_code <> 'RETURN'
689: AND NOT EXISTS
690: (SELECT 'Non Invoiceable Item Line'
691: FROM MTL_SYSTEM_ITEMS MTI
692: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
693: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
694: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
695: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'

Line 784: FROM mtl_system_items mti

780: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
781: AND ool.line_category_code <> 'RETURN'
782: AND NOT EXISTS
783: (SELECT 'Non Invoiceable Item Line'
784: FROM mtl_system_items mti
785: WHERE mti.inventory_item_id = ool.inventory_item_id
786: AND mti.organization_id = nvl(ool.ship_from_org_id,
787: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
788: AND (mti.invoiceable_item_flag = 'N'