[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
405: begin
406: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
407: INTO l_so_number, l_status_code, l_line_id
408: from PO_REQUISITION_LINES PRL,
409: PO_REQUISITION_HEADERS PRH,
410: OE_ORDER_HEADERS_ALL OOH,
411: OE_ORDER_LINES_ALL OOL,
412: PO_SYSTEM_PARAMETERS PSP
413: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
439: l_split_line_num :=0;
440: select count(OOL.LINE_ID)
441: INTO l_split_line_num
442: from PO_REQUISITION_LINES PRL,
443: PO_REQUISITION_HEADERS PRH,
444: OE_ORDER_HEADERS_ALL OOH,
445: OE_ORDER_LINES_ALL OOL,
446: PO_SYSTEM_PARAMETERS PSP
447: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
460:
461: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
462: INTO l_so_number, l_status_code, l_line_id
463: from PO_REQUISITION_LINES PRL,
464: PO_REQUISITION_HEADERS PRH,
465: OE_ORDER_HEADERS_ALL OOH,
466: OE_ORDER_LINES_ALL OOL,
467: PO_SYSTEM_PARAMETERS PSP
468: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
489: begin
490: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
491: INTO l_so_number, l_status_code, l_line_id
492: from PO_REQUISITION_LINES PRL,
493: PO_REQUISITION_HEADERS PRH,
494: OE_ORDER_HEADERS_ALL OOH,
495: OE_ORDER_LINES_ALL OOL,
496: PO_SYSTEM_PARAMETERS PSP
497: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
609: begin
610: select to_char(OOH.ORDER_NUMBER), OOH.FLOW_STATUS_CODE, OOL.LINE_ID
611: INTO l_so_number, l_status_code, l_line_id
612: from PO_REQUISITION_LINES_ALL PRL,
613: PO_REQUISITION_HEADERS_ALL PRH,
614: OE_ORDER_HEADERS_ALL OOH,
615: OE_ORDER_LINES_ALL OOL,
616: PO_SYSTEM_PARAMETERS_ALL PSP
617: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
697: begin
698:
699: select CONTRACTOR_REQUISITION_FLAG
700: into l_contractor_requisition_flag
701: from po_requisition_headers
702: where requisition_header_id = req_header_id;
703:
704: if ( l_contractor_requisition_flag = 'Y') then
705: -- contrctor requisition. There might be multiple suppliers in
787:
788: begin
789: select prh.TRANSFERRED_TO_OE_FLAG
790: into is_aSO
791: from po_requisition_headers prh
792: where prh.requisition_header_id = req_header_id;
793:
794: return is_aSO;
795:
892: begin
893: select plc_urg.displayed_field
894: into value
895: from
896: po_requisition_headers_all prh,
897: po_requisition_lines_all prl,
898: po_lookup_codes plc_urg
899: where
900: prh.requisition_header_id = req_header_id and
1325: min(PRL.REQUISITION_LINE_ID)
1326: into no_of_po, req_line_id_po
1327: FROM
1328: PO_REQUISITION_LINES_ALL PRL,
1329: PO_REQUISITION_HEADERS_ALL PRH,
1330: PO_LINE_LOCATIONS_ALL PLL,
1331: PO_RELEASES_ALL PR,
1332: PO_HEADERS_ALL PH
1333: WHERE
1348: else
1349: SELECT COUNT(DISTINCT(OOH.HEADER_ID)), min(PRL.REQUISITION_LINE_ID)
1350: into no_of_so, req_line_id_so
1351: FROM
1352: PO_REQUISITION_HEADERS PRH,
1353: PO_REQUISITION_LINES_ALL PRL,
1354: OE_ORDER_HEADERS_ALL OOH,
1355: OE_ORDER_LINES_ALL OOL,
1356: PO_SYSTEM_PARAMETERS PSP
1439: purchasing_org,
1440: placed_on_po_flag,
1441: order_status
1442: FROM
1443: PO_REQUISITION_HEADERS PRH,
1444: PO_REQUISITION_LINES_ALL PRL,
1445: OE_ORDER_HEADERS_ALL OOH,
1446: OE_ORDER_LINES_ALL OOL,
1447: PO_SYSTEM_PARAMETERS PSP
1618: wf_notifications wn,
1619: wf_notification_attributes wna,
1620: wf_user_roles wlur,
1621: fnd_user fnd,
1622: po_requisition_headers_all prh,
1623: per_all_people_f pap
1624: WHERE
1625: prh.requisition_header_id = req_header_id AND
1626: wlur.user_name = fnd.user_name AND