APPS.PO_CHG_REQUEST_PVT dependencies on PO_LOOKUP_CODES

Line 2213: po_lookup_codes polc

2209: poh.revision_num,nvl(pll.consigned_flag,'N')
2210: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2211: from po_line_locations_all pll,
2212: po_headers_all poh,
2213: po_lookup_codes polc
2214: where
2215: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2216: polc.lookup_type = 'DOCUMENT STATE' and
2217: poh.po_header_id = pll.po_header_id and

Line 2276: po_lookup_codes polc

2272: por.revision_num,nvl(pll.consigned_flag,'N')
2273: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2274: from po_line_locations_all pll,
2275: po_releases_all por,
2276: po_lookup_codes polc
2277: where
2278: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2279: polc.lookup_type = 'DOCUMENT STATE' and
2280: por.po_header_id = pll.po_header_id and