[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
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
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
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