APPS.PO_RELEASES_SV2 dependencies on PO_LOOKUP_CODES

Line 89: po_lookup_codes lk

85: x_supply_agreement_flag, --Bug#3514141
86: x_confirming_order_flag --Bug#3514141
87: from
88: po_headers ph,
89: po_lookup_codes lk
90: where
91: ph.po_header_id = X_po_header_id AND
92: lk.lookup_type (+) = 'PAY ON CODE' AND
93: lk.lookup_code (+) = ph.pay_on_code;

Line 181: po_lookup_codes plc_sta,

177: x_closed_code,
178: x_frozen_flag,
179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld

Line 182: po_lookup_codes plc_can,

178: x_frozen_flag,
179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =

Line 183: po_lookup_codes plc_clo,

179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,

Line 184: po_lookup_codes plc_fro,

180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,
188: 'R', por.approved_flag,

Line 185: po_lookup_codes plc_hld

181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,
188: 'R', por.approved_flag,
189: nvl(por.authorization_status,'INCOMPLETE'))