APPS.DPP_PURCHASEPRICE_PVT dependencies on FND_LOOKUP_VALUES

Line 857: fnd_lookup_values flv

853: nvl(por.cancel_flag,'N') = 'N' AND
854: pol.org_id = pll.org_id AND
855: pll.org_id = por.org_id
856: INNER JOIN
857: fnd_lookup_values flv
858: ON
859: flv.lookup_type = 'AUTHORIZATION STATUS' AND
860: flv.language = USERENV('LANG') AND
861: nvl(por.authorization_status ,poh.authorization_status) = flv.lookup_code

Line 886: fnd_lookup_values flv

882: pol.item_id = p_inventory_item_id AND
883: poh.vendor_id = p_vendor_id AND
884: poh.enabled_flag = 'Y'
885: INNER JOIN
886: fnd_lookup_values flv
887: ON
888: flv.lookup_type = 'AUTHORIZATION STATUS' AND
889: flv.language = USERENV('LANG') AND
890: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 904: fnd_lookup_values flv

900: po_headers_all poh,
901: po_lines_all pol,
902: po_line_locations_all pll,
903: po_releases_all por,
904: fnd_lookup_values flv
905: WHERE
906: poh.po_header_id = pol.po_header_id AND
907: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
908: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 950: fnd_lookup_values flv

946: pol.item_id = p_inventory_item_id AND
947: poh.vendor_id = p_vendor_id AND
948: poh.enabled_flag = 'Y'
949: INNER JOIN
950: fnd_lookup_values flv
951: ON
952: flv.lookup_type = 'AUTHORIZATION STATUS' AND
953: flv.language = USERENV('LANG') AND
954: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 979: fnd_lookup_values flv

975: pol.item_id = p_inventory_item_id AND
976: poh.vendor_id = p_vendor_id AND
977: poh.enabled_flag = 'Y'
978: INNER JOIN
979: fnd_lookup_values flv
980: ON
981: flv.lookup_type = 'AUTHORIZATION STATUS' AND
982: flv.language = USERENV('LANG') AND
983: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 1027: fnd_lookup_values flv

1023: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1024: nvl(por.cancel_flag,'N') = 'N' AND
1025: pll.org_id = por.org_id
1026: INNER JOIN
1027: fnd_lookup_values flv
1028: ON
1029: flv.lookup_type = 'AUTHORIZATION STATUS' AND
1030: flv.language = USERENV('LANG') AND
1031: nvl(por.authorization_status ,poh.authorization_status) = flv.lookup_code;