[Home] [Help]
2080: p_sequence + ROWNUM,
2081: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
2082: 'PO_ATO_ITEM_NA'
2083: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
2084: MTL_SYSTEM_ITEMS MSI
2085: WHERE PRL.requisition_header_id = p_document_id AND
2086: nvl(PRL.cancel_flag, 'N') = 'N' AND
2087: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
2088: PRL.item_id is not null AND
3304: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim
3305: ||l_textline,1,240),
3306: --
3307: 'PO_SUB_ITEM_NOT_APPROVED_REL'
3308: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
3309: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
3310: FINANCIALS_SYSTEM_PARAMETERS FSP
3311: WHERE POR.po_release_id = p_document_id
3312: AND POR.po_header_id = POH.po_header_id
3420: AND nvl(PLL.cancel_flag,'N') = 'N'
3421: AND exists
3422: (SELECT 1
3423: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
3424: MTL_SYSTEM_ITEMS MSI --Bug5597639
3425: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3426: /*Bug5553138 Adding the below three conditions */
3427: AND MSI.organization_id = FSP.inventory_organization_id
3428: AND MSI.inventory_item_id = POL.item_id
3492: 'PO_ATO_ITEM_NA'
3493: FROM po_lines POL,
3494: po_line_locations_gt PLL,
3495: financials_system_parameters FSP,
3496: mtl_system_items MSI
3497: WHERE PLL.po_release_id = p_document_id
3498: AND PLL.po_line_id = POL.po_line_id
3499: AND POL.item_id is not null
3500: AND nvl(POL.cancel_flag, 'N') = 'N' --Bug5353423
3544: 0,
3545: p_sequence + ROWNUM,
3546: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
3547: 'PO_ALL_NO_ITEM'
3548: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
3549: where itm.inventory_item_id = pl.item_id
3550: and pl.item_id is not null
3551:
3552: and pl.po_line_id = pll.po_line_id
4474: -- bug 432746.
4475: SELECT NVL(MSI.price_tolerance_percent/100,
4476: NVL(POSP.price_change_allowance/100,-1))
4477: INTO l_price_tolerance_allowed
4478: FROM MTL_SYSTEM_ITEMS MSI,
4479: PO_SYSTEM_PARAMETERS POSP,
4480: FINANCIALS_SYSTEM_PARAMETERS FSP
4481: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
4482: AND MSI.organization_id(+) = FSP.inventory_organization_id;
6313: substr(g_linemsg||g_delim||POL.line_num||g_delim||
6314: g_shipmsg||g_delim||PLL.shipment_num||g_delim
6315: ||l_textline,1,240),
6316: 'PO_SUB_ITEM_NOT_APPROVED'
6317: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
6318: PO_LINES_GT POL, PO_HEADERS_GT POH,
6319: FINANCIALS_SYSTEM_PARAMETERS FSP
6320: WHERE POH.po_header_id = p_document_id
6321: AND POH.po_header_id = POL.po_header_id
6423: AND nvl(PLL.cancel_flag,'N') = 'N'
6424: AND exists
6425: (SELECT 1
6426: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
6427: MTL_SYSTEM_ITEMS MSI --Bug5597639
6428: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
6429: /*Bug5597639 Adding the below three conditions */
6430: AND MSI.organization_id = FSP.inventory_organization_id
6431: AND MSI.inventory_item_id = POL.item_id
6612: 'PO_ATO_ITEM_NA'
6613: FROM po_lines_gt POL,
6614: po_headers_gt POH,
6615: financials_system_parameters FSP,
6616: mtl_system_items MSI
6617: WHERE POH.po_header_id = p_document_id
6618: AND POL.po_header_id = POH.po_header_id
6619: AND POL.item_id is not null
6620: AND nvl(POL.cancel_flag, 'N') = 'N' --5353423
6663: 0,
6664: p_sequence + ROWNUM,
6665: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
6666: 'PO_ALL_NO_ITEM'
6667: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
6668: where itm.inventory_item_id = pl.item_id
6669: and pl.item_id is not null
6670: and itm.organization_id = fsp.inventory_organization_id
6671: and itm.purchasing_enabled_flag = 'N'
6710: p_sequence + ROWNUM,
6711: substr(g_linemsg||g_delim||pl.line_num||g_delim||
6712: g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
6713: 'PO_ALL_NO_ITEM'
6714: from po_headers_gt ph,po_lines_gt pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
6715: where itm.inventory_item_id = pl.item_id
6716: and pl.item_id is not null
6717: and itm.organization_id = pll.ship_to_organization_id
6718: and itm.purchasing_enabled_flag = 'N'
6778: FROM po_lines_gt POL,
6779: po_headers_gt POH,
6780: po_line_locations_gt PLL,
6781: financials_system_parameters FSP,
6782: mtl_system_items MSI
6783: WHERE POH.po_header_id = p_document_id
6784: AND POL.po_header_id = POH.po_header_id
6785: AND POL.po_line_id = PLL.po_line_id
6786: AND PLL.po_header_id = POH.po_header_id
7807: 0,
7808: p_sequence + ROWNUM,
7809: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
7810: 'PO_ALL_NO_ITEM'
7811: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
7812: where itm.inventory_item_id = pl.item_id
7813: and pl.item_id is not null
7814: and itm.organization_id = fsp.inventory_organization_id
7815: and itm.purchasing_enabled_flag = 'N'