APPS.DPP_PURCHASEPRICE_PVT dependencies on FND_LOOKUP_VALUES

Line 866: fnd_lookup_values flv

862: nvl(por.cancel_flag,'N') = 'N' AND
863: pol.org_id = pll.org_id AND
864: pll.org_id = por.org_id
865: INNER JOIN
866: fnd_lookup_values flv
867: ON
868: flv.lookup_type = 'AUTHORIZATION STATUS' AND
869: flv.language = USERENV('LANG') AND
870: nvl(por.authorization_status ,poh.authorization_status) = flv.lookup_code

Line 895: fnd_lookup_values flv

891: pol.item_id = p_inventory_item_id AND
892: poh.vendor_id = p_vendor_id AND
893: poh.enabled_flag = 'Y'
894: INNER JOIN
895: fnd_lookup_values flv
896: ON
897: flv.lookup_type = 'AUTHORIZATION STATUS' AND
898: flv.language = USERENV('LANG') AND
899: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 913: fnd_lookup_values flv

909: po_headers_all poh,
910: po_lines_all pol,
911: po_line_locations_all pll,
912: po_releases_all por,
913: fnd_lookup_values flv
914: WHERE
915: poh.po_header_id = pol.po_header_id AND
916: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
917: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 959: fnd_lookup_values flv

955: pol.item_id = p_inventory_item_id AND
956: poh.vendor_id = p_vendor_id AND
957: poh.enabled_flag = 'Y'
958: INNER JOIN
959: fnd_lookup_values flv
960: ON
961: flv.lookup_type = 'AUTHORIZATION STATUS' AND
962: flv.language = USERENV('LANG') AND
963: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 988: fnd_lookup_values flv

984: pol.item_id = p_inventory_item_id AND
985: poh.vendor_id = p_vendor_id AND
986: poh.enabled_flag = 'Y'
987: INNER JOIN
988: fnd_lookup_values flv
989: ON
990: flv.lookup_type = 'AUTHORIZATION STATUS' AND
991: flv.language = USERENV('LANG') AND
992: nvl(poh.authorization_status,'INCOMPLETE') = flv.lookup_code

Line 1036: fnd_lookup_values flv

1032: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1033: nvl(por.cancel_flag,'N') = 'N' AND
1034: pll.org_id = por.org_id
1035: INNER JOIN
1036: fnd_lookup_values flv
1037: ON
1038: flv.lookup_type = 'AUTHORIZATION STATUS' AND
1039: flv.language = USERENV('LANG') AND
1040: nvl(por.authorization_status ,poh.authorization_status) = flv.lookup_code;