DBA Data[Home] [Help]

APPS.POS_WC_CREATE_UPDATE_PVT dependencies on PO_HEADERS_ALL

Line 106: -- PO_HEADERS_ALL, and identifies the PO for which the

102: -- and approved amount
103: --Parameter :
104: --IN : p_po_header_id IN NUMBER Required
105: -- corresponds to the columne PO_HEADER_ID in the table
106: -- PO_HEADERS_ALL, and identifies the PO for which the
107: -- information should be retrieved.
108: --
109: --OUT : x_ordered OUT NUMBER
110: -- total ordered amount for the PO

Line 202: -- PO_HEADERS_ALL, and identifies the PO for which the

198: --Function : Retrieve approved amount of a PO
199: --Parameter :
200: --IN : p_po_header_id IN NUMBER Required
201: -- corresponds to the columne PO_HEADER_ID in the table
202: -- PO_HEADERS_ALL, and identifies the PO for which the
203: -- information should be retrieved.
204: --
205: --OUT : x_approved OUT NUMBER
206: -- total approved amount for the PO

Line 254: -- PO_HEADERS_ALL, and identifies the PO for which the

250: --Function : Retrieve approved amount of a PO
251: --Parameter :
252: --IN : p_po_header_id IN NUMBER Required
253: -- corresponds to the columne PO_HEADER_ID in the table
254: -- PO_HEADERS_ALL, and identifies the PO for which the
255: -- information should be retrieved.
256: --
257: --OUT : x_ordered OUT NUMBER
258: -- total ordered amount for the PO

Line 825: po_headers_all ph,

821: FROM
822: --po_distributions_all pod,
823: po_line_locations_all pll,
824: po_lines_all pl,
825: po_headers_all ph,
826: rcv_shipment_lines rsl,
827: rcv_shipment_headers rsh
828: WHERE
829: rsh.shipment_header_id = l_shipment_header_id