[Home] [Help]
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'
617: OR mti.invoice_enabled_flag = 'N'));
618:
619: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
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))
632: AND (mti.invoiceable_item_flag = 'N'
633: OR mti.invoice_enabled_flag = 'N'));
634: ELSE
635: -- Select the Outbound Extended Price for lines that have committment
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'
655: OR mti.invoice_enabled_flag = 'N'));
656: END IF;
657:
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'
720: OR MTI.INVOICE_ENABLED_FLAG = 'N'))
721: --Bug 6072691
722: --AND NVL(P.INVOICED_FLAG, 'N') = 'N';
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'
813: OR mti.invoice_enabled_flag = 'N'));
814: EXCEPTION
815: WHEN no_data_found THEN