[Home] [Help]
340: or source_type_code = 'INVENTORY'
341: or NVL(line_location_id, -999) <> -999
342: or exists
343: (select 'Req Header auth_status is not approved or contractor_status is pending'
344: from po_requisition_headers_all prha
345: where prha.requisition_header_id = prla.requisition_header_id
346: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
347: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
348: THEN null
1561: l_preparer_id NUMBER;
1562: l_username VARCHAR2(100);
1563: l_user_display_name VARCHAR2(240);
1564: l_line_num_display VARCHAR2(10);
1565: l_req_num po_requisition_headers_all.segment1%type;
1566: l_req_line_num po_requisition_lines_all.line_num_display%TYPE;
1567: l_document_number VARCHAR2(100);
1568: l_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
1569: l_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
1612: FROM pon_backing_requisitions pbr,
1613: pon_auction_item_prices_all paip,
1614: pon_auction_headers_all pah,
1615: po_requisition_lines_all prl,
1616: po_requisition_headers_all prh
1617: WHERE pbr.auction_header_id = p_document_id
1618: AND pbr.line_number = p_document_line_id
1619: AND paip.auction_header_id = pbr.auction_header_id
1620: AND paip.line_number = pbr.line_number
1641: poh.type_lookup_code,
1642: prl.item_description,
1643: poh.agent_id
1644: FROM po_requisition_lines_all prl,
1645: po_requisition_headers_all prh,
1646: po_req_distributions_all prd,
1647: po_headers_draft_all poh,
1648: po_lines_draft_all pol,
1649: po_distributions_draft_all pod,
1685: poh.type_lookup_code,
1686: prl.item_description,
1687: poh.agent_id
1688: FROM po_requisition_lines_all prl,
1689: po_requisition_headers_all prh,
1690: po_headers_draft_all poh,
1691: po_lines_draft_all pol,
1692: po_drafts pd
1693: