DBA Data[Home] [Help]

APPS.PO_REQS_INQ_SV dependencies on PO_SYSTEM_PARAMETERS

Line 108: from po_system_parameters;

104:
105: /* replacing the select statement with the new OE API. */
106: select order_source_id
107: into x_order_source_id
108: from po_system_parameters;
109:
110: --Bug# 1392077
111: --Toju George 08/31/2000
112: --Modified the call to procedure to replace req_num and line_num with ids.

Line 125: PO_SYSTEM_PARAMETERS POSP

121:
122: /* SELECT decode(SOL.shipped_quantity,NULL,0,SOL.shipped_quantity)
123: INTO X_shipped_quantity
124: FROM SO_LINES SOL, SO_HEADERS SOH,
125: PO_SYSTEM_PARAMETERS POSP
126: WHERE SOH.original_system_reference = X_requisition_num
127: AND SOH.original_system_source_code =
128: to_char(POSP.order_source_id)
129: AND SOH.header_id = SOL.header_id