[Home] [Help]
20: FROM
21: wf_notifications wn,
22: wf_user_roles wlur,
23: fnd_user fnd,
24: po_requisition_headers_all prh,
25: per_phones ph,
26: per_all_people_f pap
27: WHERE
28: prh.requisition_header_id = 140331 AND
329: begin
330: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
331: INTO l_so_number, l_status_code, l_line_id
332: from PO_REQUISITION_LINES PRL,
333: PO_REQUISITION_HEADERS PRH,
334: OE_ORDER_HEADERS_ALL OOH,
335: OE_ORDER_LINES_ALL OOL,
336: PO_SYSTEM_PARAMETERS PSP
337: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
362: l_split_line_num :=0;
363: select count(OOL.LINE_ID)
364: INTO l_split_line_num
365: from PO_REQUISITION_LINES PRL,
366: PO_REQUISITION_HEADERS PRH,
367: OE_ORDER_HEADERS_ALL OOH,
368: OE_ORDER_LINES_ALL OOL,
369: PO_SYSTEM_PARAMETERS PSP
370: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
383:
384: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
385: INTO l_so_number, l_status_code, l_line_id
386: from PO_REQUISITION_LINES PRL,
387: PO_REQUISITION_HEADERS PRH,
388: OE_ORDER_HEADERS_ALL OOH,
389: OE_ORDER_LINES_ALL OOL,
390: PO_SYSTEM_PARAMETERS PSP
391: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
412: begin
413: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
414: INTO l_so_number, l_status_code, l_line_id
415: from PO_REQUISITION_LINES PRL,
416: PO_REQUISITION_HEADERS PRH,
417: OE_ORDER_HEADERS_ALL OOH,
418: OE_ORDER_LINES_ALL OOL,
419: PO_SYSTEM_PARAMETERS PSP
420: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
532: begin
533: select to_char(OOH.ORDER_NUMBER), OOH.FLOW_STATUS_CODE, OOL.LINE_ID
534: INTO l_so_number, l_status_code, l_line_id
535: from PO_REQUISITION_LINES_ALL PRL,
536: PO_REQUISITION_HEADERS_ALL PRH,
537: OE_ORDER_HEADERS_ALL OOH,
538: OE_ORDER_LINES_ALL OOL,
539: PO_SYSTEM_PARAMETERS_ALL PSP
540: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
619: begin
620:
621: select CONTRACTOR_REQUISITION_FLAG
622: into l_contractor_requisition_flag
623: from po_requisition_headers
624: where requisition_header_id = req_header_id;
625:
626: if ( l_contractor_requisition_flag = 'Y') then
627: -- contrctor requisition. There might be multiple suppliers in
709:
710: begin
711: select prh.TRANSFERRED_TO_OE_FLAG
712: into is_aSO
713: from po_requisition_headers prh
714: where prh.requisition_header_id = req_header_id;
715:
716: return is_aSO;
717:
814: begin
815: select plc_urg.displayed_field
816: into value
817: from
818: po_requisition_headers_all prh,
819: po_requisition_lines_all prl,
820: po_lookup_codes plc_urg
821: where
822: prh.requisition_header_id = req_header_id and
1202: min(PRL.REQUISITION_LINE_ID)
1203: into no_of_po, req_line_id_po
1204: FROM
1205: PO_REQUISITION_LINES_ALL PRL,
1206: PO_REQUISITION_HEADERS_ALL PRH,
1207: PO_LINE_LOCATIONS_ALL PLL,
1208: PO_RELEASES_ALL PR,
1209: PO_HEADERS_ALL PH
1210: WHERE
1225: else
1226: SELECT COUNT(DISTINCT(OOH.HEADER_ID)), min(PRL.REQUISITION_LINE_ID)
1227: into no_of_so, req_line_id_so
1228: FROM
1229: PO_REQUISITION_HEADERS PRH,
1230: PO_REQUISITION_LINES_ALL PRL,
1231: OE_ORDER_HEADERS_ALL OOH,
1232: OE_ORDER_LINES_ALL OOL,
1233: PO_SYSTEM_PARAMETERS PSP
1316: purchasing_org,
1317: placed_on_po_flag,
1318: order_status
1319: FROM
1320: PO_REQUISITION_HEADERS PRH,
1321: PO_REQUISITION_LINES_ALL PRL,
1322: OE_ORDER_HEADERS_ALL OOH,
1323: OE_ORDER_LINES_ALL OOL,
1324: PO_SYSTEM_PARAMETERS PSP
1495: wf_notifications wn,
1496: wf_notification_attributes wna,
1497: wf_user_roles wlur,
1498: fnd_user fnd,
1499: po_requisition_headers_all prh,
1500: per_all_people_f pap
1501: WHERE
1502: prh.requisition_header_id = req_header_id AND
1503: wlur.user_name = fnd.user_name AND