APPS.OE_OE_TOTALS_SUMMARY dependencies on MTL_SYSTEM_ITEMS

Line 612: FROM mtl_system_items mti

608: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
609: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
610: AND NOT EXISTS
611: (SELECT 'Non Invoiceable Item Line'
612: FROM mtl_system_items mti
613: WHERE mti.inventory_item_id = ool.inventory_item_id
614: AND mti.organization_id = nvl(ool.ship_from_org_id,
615: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
616: AND (mti.invoiceable_item_flag = 'N'

Line 627: FROM mtl_system_items mti, oe_order_lines_all ool

623: FROM oe_payments op
624: WHERE op.header_id = p_header_id
625: AND NOT EXISTS
626: (SELECT 'Non Invoiceable Item Line'
627: FROM mtl_system_items mti, oe_order_lines_all ool
628: WHERE ool.line_id = op.line_id
629: AND 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))

Line 650: FROM mtl_system_items mti

646: AND ool.line_category_code <> 'RETURN'
647: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
648: AND NOT EXISTS
649: (SELECT 'Non Invoiceable Item Line'
650: FROM mtl_system_items mti
651: WHERE mti.inventory_item_id = ool.inventory_item_id
652: AND mti.organization_id = nvl(ool.ship_from_org_id,
653: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
654: AND (mti.invoiceable_item_flag = 'N'

Line 715: FROM MTL_SYSTEM_ITEMS MTI

711: OR nvl(p_all_lines, 'N') = 'Y' )
712: AND L.line_category_code <> 'RETURN'
713: AND NOT EXISTS
714: (SELECT 'Non Invoiceable Item Line'
715: FROM MTL_SYSTEM_ITEMS MTI
716: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
717: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
718: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
719: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'

Line 808: FROM mtl_system_items mti

804: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
805: AND ool.line_category_code <> 'RETURN'
806: AND NOT EXISTS
807: (SELECT 'Non Invoiceable Item Line'
808: FROM mtl_system_items mti
809: WHERE mti.inventory_item_id = ool.inventory_item_id
810: AND mti.organization_id = nvl(ool.ship_from_org_id,
811: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
812: AND (mti.invoiceable_item_flag = 'N'