APPS.PO_ASL_API_PUB dependencies on PO_LOOKUP_CODES

Line 1533: FROM po_lookup_codes polc

1529:
1530: UPDATE po_asl_documents_gt padt
1531: SET padt.document_type_code =
1532: (SELECT polc.lookup_code
1533: FROM po_lookup_codes polc
1534: WHERE polc.lookup_type = 'SOURCE DOCUMENT TYPE'
1535: AND Upper(polc.displayed_field) = Upper(padt.document_type_dsp)
1536: AND ROWNUM < 2)
1537: WHERE padt.document_type_dsp IS NOT NULL;

Line 1602: FROM po_lookup_codes polc

1598:
1599: UPDATE chv_authorizations_gt chv
1600: SET chv.authorization_code =
1601: (SELECT polc.lookup_code
1602: FROM po_lookup_codes polc
1603: WHERE polc.lookup_type = 'AUTHORIZATION_TYPE'
1604: AND polc.displayed_field = chv.authorization_code_dsp
1605: AND ROWNUM < 2)
1606: WHERE chv.authorization_code_dsp IS NOT NULL;

Line 1674: FROM po_lookup_codes polc

1670:
1671: UPDATE po_asl_attributes_gt paa
1672: SET paa.release_generation_method =
1673: (SELECT polc.lookup_code
1674: FROM po_lookup_codes polc
1675: WHERE polc.lookup_type = 'DOC GENERATION METHOD'
1676: AND polc.displayed_field = paa.release_generation_method_dsp
1677: AND ROWNUM < 2)
1678: WHERE paa.release_generation_method_dsp IS NOT NULL;

Line 1684: FROM po_lookup_codes polc

1680:
1681: UPDATE po_asl_attributes_gt paa
1682: SET paa.plan_schedule_type =
1683: (SELECT polc.lookup_code
1684: FROM po_lookup_codes polc
1685: WHERE polc.lookup_type = 'PLAN_SCHEDULE_SUBTYPE'
1686: AND polc.displayed_field = paa.plan_schedule_type_dsp
1687: AND ROWNUM < 2)
1688: WHERE paa.plan_schedule_type_dsp IS NOT NULL;

Line 1694: FROM po_lookup_codes polc

1690:
1691: UPDATE po_asl_attributes_gt paa
1692: SET paa.ship_schedule_type =
1693: (SELECT polc.lookup_code
1694: FROM po_lookup_codes polc
1695: WHERE polc.lookup_type = 'SHIP_SCHEDULE_SUBTYPE'
1696: AND polc.displayed_field = paa.ship_schedule_type_dsp
1697: AND ROWNUM < 2)
1698: WHERE paa.ship_schedule_type_dsp IS NOT NULL;

Line 2650: FROM po_lookup_codes plc,

2646: THEN
2647: po_asl_api_pvt.log('inside if');
2648: SELECT poh.po_header_id
2649: INTO l_header_id
2650: FROM po_lookup_codes plc,
2651: po_headers_all poh,
2652: hr_operating_units hrou
2653: WHERE poh.org_id = hrou.organization_id(+)
2654: AND poh.type_lookup_code = p_doc_type

Line 2752: FROM po_lookup_codes plc,

2748: THEN
2749: po_asl_api_pvt.log('inside else if');
2750: SELECT poh.po_header_id
2751: INTO l_header_id
2752: FROM po_lookup_codes plc,
2753: po_headers_all poh,
2754: hr_operating_units hrou
2755: WHERE poh.org_id = hrou.organization_id(+)
2756: AND poh.type_lookup_code = p_doc_type