[Home] [Help]
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'
51: OR mti.invoice_enabled_flag = 'N'));
52:
53: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
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'))
66: AND (mti.invoiceable_item_flag = 'N'
67: OR mti.invoice_enabled_flag = 'N'));
68: ELSE
69: -- Select the Outbound Extended Price for lines that have committment
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'
85: OR mti.invoice_enabled_flag = 'N'));
86: END IF;
87:
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'
133: OR MTI.INVOICE_ENABLED_FLAG = 'N'));
134:
135: l_charges := nvl(l_chgs_wo_line_id,0) + nvl(l_chgs_w_line_id,0);
3312: ,p_change_sequence => l_change_sequence
3313: ,p_source_document_type_id => l_source_document_type_id
3314: ,p_source_document_id => l_source_document_id);
3315:
3316: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3317:
3318: -- MOAC changes
3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3320: SELECT org_id