[Home] [Help]
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'
598: OR mti.invoice_enabled_flag = 'N'));
599:
600: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
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))
613: AND (mti.invoiceable_item_flag = 'N'
614: OR mti.invoice_enabled_flag = 'N'));
615: ELSE
616: -- Select the Outbound Extended Price for lines that have committment
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'
633: OR mti.invoice_enabled_flag = 'N'));
634: END IF;
635:
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'
696: OR MTI.INVOICE_ENABLED_FLAG = 'N'))
697: --Bug 6072691
698: --AND NVL(P.INVOICED_FLAG, 'N') = 'N';
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'
789: OR mti.invoice_enabled_flag = 'N'));
790: EXCEPTION
791: WHEN no_data_found THEN