[Home] [Help]
3879: p_sequence + ROWNUM,
3880: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
3881: 'PO_ATO_ITEM_NA'
3882: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
3883: MTL_SYSTEM_ITEMS MSI
3884: WHERE PRL.requisition_header_id = p_document_id AND
3885: nvl(PRL.cancel_flag, 'N') = 'N' AND
3886: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
3887: PRL.item_id is not null AND
5141: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim
5142: ||l_textline,1,240),
5143: --
5144: 'PO_SUB_ITEM_NOT_APPROVED_REL'
5145: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
5146: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
5147: FINANCIALS_SYSTEM_PARAMETERS FSP
5148: WHERE POR.po_release_id = p_document_id
5149: AND POR.po_header_id = POH.po_header_id
5257: AND nvl(PLL.cancel_flag,'N') = 'N'
5258: AND exists
5259: (SELECT 1
5260: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
5261: MTL_SYSTEM_ITEMS MSI --Bug5597639
5262: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
5263: /*Bug5553138 Adding the below three conditions */
5264: AND MSI.organization_id = FSP.inventory_organization_id
5265: AND MSI.inventory_item_id = POL.item_id
5329: 'PO_ATO_ITEM_NA'
5330: FROM po_lines POL,
5331: po_line_locations_gt PLL,
5332: financials_system_parameters FSP,
5333: mtl_system_items MSI
5334: WHERE PLL.po_release_id = p_document_id
5335: AND PLL.po_line_id = POL.po_line_id
5336: AND POL.item_id is not null
5337: AND nvl(POL.cancel_flag, 'N') = 'N' --Bug5353423
5381: 0,
5382: p_sequence + ROWNUM,
5383: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
5384: 'PO_ALL_NO_ITEM'
5385: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
5386: where itm.inventory_item_id = pl.item_id
5387: and pl.item_id is not null
5388:
5389: and pl.po_line_id = pll.po_line_id
6416: --the requisition price and shipment price.
6417: SELECT NVL(MSI.price_tolerance_percent/100,
6418: NVL(POSP.price_change_allowance/100,-1))
6419: INTO l_price_tolerance_allowed
6420: FROM MTL_SYSTEM_ITEMS MSI,
6421: PO_SYSTEM_PARAMETERS POSP,
6422: FINANCIALS_SYSTEM_PARAMETERS FSP
6423: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
6424: AND MSI.organization_id(+) = FSP.inventory_organization_id;
8960: substr(g_linemsg||g_delim||POL.line_num||g_delim||
8961: g_shipmsg||g_delim||PLL.shipment_num||g_delim
8962: ||l_textline,1,240),
8963: 'PO_SUB_ITEM_NOT_APPROVED'
8964: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
8965: PO_LINES_GT POL, PO_HEADERS_GT POH,
8966: FINANCIALS_SYSTEM_PARAMETERS FSP
8967: WHERE POH.po_header_id = p_document_id
8968: AND POH.po_header_id = POL.po_header_id
9077: AND nvl(PLL.cancel_flag,'N') = 'N'
9078: AND exists
9079: (SELECT 1
9080: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
9081: MTL_SYSTEM_ITEMS MSI --Bug5597639
9082: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
9083: /*Bug5597639 Adding the below three conditions */
9084: AND MSI.organization_id = FSP.inventory_organization_id
9085: AND MSI.inventory_item_id = POL.item_id
9266: 'PO_ATO_ITEM_NA'
9267: FROM po_lines_gt POL,
9268: po_headers_gt POH,
9269: financials_system_params_all FSP,
9270: mtl_system_items MSI
9271: WHERE fsp.org_id = poh.org_id
9272: AND POH.po_header_id = p_document_id
9273: AND POL.po_header_id = POH.po_header_id
9274: AND POL.item_id is not null
9319: 0,
9320: p_sequence + ROWNUM,
9321: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
9322: 'PO_ALL_NO_ITEM'
9323: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_params_all fsp,po_line_types_b plt
9324: where fsp.org_id = ph.org_id
9325: and itm.inventory_item_id = pl.item_id
9326: and pl.item_id is not null
9327: and itm.organization_id = fsp.inventory_organization_id
9368: p_sequence + ROWNUM,
9369: substr(g_linemsg||g_delim||pl.line_num||g_delim||
9370: g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
9371: 'PO_ALL_NO_ITEM'
9372: from po_headers_gt ph,po_lines_gt pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
9373: where itm.inventory_item_id = pl.item_id
9374: and pl.item_id is not null
9375: and itm.organization_id = pll.ship_to_organization_id
9376: and itm.purchasing_enabled_flag = 'N'
9436: FROM po_lines_gt POL,
9437: po_headers_gt POH,
9438: po_line_locations_gt PLL,
9439: financials_system_parameters FSP,
9440: mtl_system_items MSI
9441: WHERE POH.po_header_id = p_document_id
9442: AND POL.po_header_id = POH.po_header_id
9443: AND POL.po_line_id = PLL.po_line_id
9444: AND PLL.po_header_id = POH.po_header_id
10937: 0,
10938: p_sequence + ROWNUM,
10939: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
10940: 'PO_ALL_NO_ITEM'
10941: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
10942: where itm.inventory_item_id = pl.item_id
10943: and pl.item_id is not null
10944: and itm.organization_id = fsp.inventory_organization_id
10945: and itm.purchasing_enabled_flag = 'N'
11151: AND nvl(PLL.cancel_flag,'N') = 'N'
11152: AND exists
11153: (SELECT 1
11154: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
11155: MTL_SYSTEM_ITEMS MSI --Bug5597639
11156: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
11157: /*Bug5597639 Adding the below three conditions */
11158: AND MSI.organization_id = FSP.inventory_organization_id
11159: AND MSI.inventory_item_id = POL.item_id