DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_LOOKUP_CODES

Line 2360: po_lookup_codes polc

2356: poh.revision_num,nvl(pll.consigned_flag,'N')
2357: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2358: from po_line_locations_all pll,
2359: po_headers_all poh,
2360: po_lookup_codes polc
2361: where
2362: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2363: polc.lookup_type = 'DOCUMENT STATE' and
2364: poh.po_header_id = pll.po_header_id and

Line 2423: po_lookup_codes polc

2419: por.revision_num,nvl(pll.consigned_flag,'N')
2420: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2421: from po_line_locations_all pll,
2422: po_releases_all por,
2423: po_lookup_codes polc
2424: where
2425: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2426: polc.lookup_type = 'DOCUMENT STATE' and
2427: por.po_header_id = pll.po_header_id and