DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 24: po_requisition_headers_all prh,

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

Line 613: PO_REQUISITION_HEADERS_ALL PRH,

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

Line 896: po_requisition_headers_all prh,

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

Line 1329: PO_REQUISITION_HEADERS_ALL PRH,

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

Line 1622: po_requisition_headers_all prh,

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