eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PRINTING_PKG dependencies on FND_LOOKUP_VALUES

Line 938: from fnd_lookup_values flv

934: and pbp.AUCTION_HEADER_ID = petr.AUCTION_HEADER_ID
935: and petr.status_lookup_code = 'RECEIVED')
936: ) AS EMD_RECEIVED_CURRENCY,
937: (select flv.meaning --Modify by Chaoqun 05-Mar-2009
938: from fnd_lookup_values flv
939: where flv.lookup_type = 'PON_EMD_SUPPLIER_STATUS'
940: AND flv.language = USERENV('LANG')
941: AND flv.lookup_code = decode(pet.status_lookup_code,
942: null,

Line 980: , fnd_lookup_values flv

976: )
977: and application_id = 396
978: and language_code = l_printing_language) as GENERIC_MESSAGES
979: FROM pon_auction_headers_all pah
980: , fnd_lookup_values flv
981: -- , FND_USER fu
982: WHERE pah.auction_header_id = p_auction_header_id --Using the variable p_auction_header_id
983: and flv.lookup_type(+) = 'PON_AUCTION_EMD_TYPE'
984: and flv.language(+) = USERENV('LANG')

Line 1121: from fnd_lookup_values flv

1117: fl.meaning as EMD_TYPE_MEANING,
1118: paha.emd_guarantee_expiry_date as EMD_GUARANTEE_EXPIRY_DATE,
1119: paha.currency_code as EMD_CURR_CODE,
1120: (select flv.meaning
1121: from fnd_lookup_values flv
1122: where flv.lookup_type = 'PON_EMD_SUPPLIER_STATUS'
1123: AND flv.language = USERENV('LANG')
1124: AND flv.lookup_code = l_emd_current_status
1125: ) as EMD_CURRENT_STATUS,

Line 1166: fnd_lookup_values fl,

1162: and application_id = 396
1163: and language_code = l_printing_language) as GENERIC_MESSAGES
1164: from pon_auction_headers_all paha,
1165: pon_bidding_parties pbp,
1166: fnd_lookup_values fl,
1167: fnd_lookups fl1,
1168: pon_auc_doctypes doc,
1169: HZ_PARTIES hz
1170: where paha.auction_header_id = p_auction_header_id

Line 1196: from fnd_lookup_values flv

1192: fl.meaning as EMD_TYPE_MEANING,
1193: paha.emd_guarantee_expiry_date as EMD_GUARANTEE_EXPIRY_DATE,
1194: paha.currency_code as EMD_CURR_CODE,
1195: (select flv.meaning
1196: from fnd_lookup_values flv
1197: where flv.lookup_type = 'PON_EMD_SUPPLIER_STATUS'
1198: AND flv.language = USERENV('LANG')
1199: AND flv.lookup_code = l_emd_current_status
1200: ) as EMD_CURRENT_STATUS, --Modify by Chaoqun 09-Mar-2009

Line 1236: fnd_lookup_values flv

1232: or petr.status_lookup_code = 'RECEIVED'
1233: or petr.status_lookup_code = 'RECEIVE_ERROR')) as EMD_RECEIVED_DATE,
1234: (select flv.meaning
1235: from PON_EMD_TRANSACTIONS petr,
1236: fnd_lookup_values flv
1237: where petr.AUCTION_HEADER_ID = p_auction_header_id
1238: AND petr.SUPPLIER_SEQUENCE = p_supplier_sequence
1239: AND flv.lookup_type = 'PON_EMD_PAYMENT_METHOD'
1240: AND flv.language = USERENV('LANG')

Line 1357: fnd_lookup_values flv,

1353: --End: Addde by Chaoqun on 22-DEC-2008
1354: petr.emd_transaction_id as TRX_ID
1355: from pon_emd_transactions petr,
1356: pon_bidding_parties pbp,
1357: fnd_lookup_values flv,
1358: IBY_CREDITCARD cc
1359: where petr.auction_header_id = p_auction_header_id
1360: and pbp.auction_header_id= p_auction_header_id
1361: and pbp.sequence= p_supplier_sequence

Line 1414: fnd_lookup_values fl,

1410: and language_code = l_printing_language) as GENERIC_MESSAGES
1411: from pon_auction_headers_all paha,
1412: pon_emd_transactions petr,
1413: pon_bidding_parties pbp,
1414: fnd_lookup_values fl,
1415: fnd_lookups fl1,
1416: pon_auc_doctypes doc,
1417: HZ_PARTIES hz
1418: where paha.auction_header_id = p_auction_header_id

Line 1557: fnd_lookup_values flv,

1553: petr.TYPE_OF_CARD as EMD_TYPE_OF_CARD,
1554: flv.meaning as EMD_DETAIL_PAYTYPE,
1555: petr.emd_transaction_id as TRX_ID
1556: from pon_emd_transactions petr,
1557: fnd_lookup_values flv,
1558: IBY_CREDITCARD cc
1559: where petr.auction_header_id = p_auction_header_id
1560: and petr.supplier_sequence = p_supplier_sequence
1561: and petr.status_lookup_code = 'RECEIVED'

Line 1632: fnd_lookup_values flv,

1628: and language_code = l_printing_language) as GENERIC_MESSAGES
1629: from pon_auction_headers_all paha,
1630: pon_emd_transactions petr,
1631: pon_bidding_parties pbp,
1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,
1634: pon_auc_doctypes doc,
1635: fnd_lookups f1,
1636: HZ_PARTIES hz

Line 2556: fnd_lookup_values fl_freight_terms ,

2552: fnd_lookups fl2,
2553: fnd_lookups flbr ,
2554: fnd_lookups fl_rank_ind,
2555: fnd_lookups fl_pf_type_allowed,
2556: fnd_lookup_values fl_freight_terms ,
2557: fnd_lookup_values flv,
2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,

Line 2557: fnd_lookup_values flv,

2553: fnd_lookups flbr ,
2554: fnd_lookups fl_rank_ind,
2555: fnd_lookups fl_pf_type_allowed,
2556: fnd_lookup_values fl_freight_terms ,
2557: fnd_lookup_values flv,
2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,

Line 2559: fnd_lookup_values fl_fob ,

2555: fnd_lookups fl_pf_type_allowed,
2556: fnd_lookup_values fl_freight_terms ,
2557: fnd_lookup_values flv,
2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,

Line 2583: fnd_lookup_values fl_bid

2579: fnd_user buyer_user,
2580: per_phones buyer_phone,
2581: per_phones buyer_fax,
2582: pon_bid_headers pbhs,
2583: fnd_lookup_values fl_bid
2584: where pah.auction_header_id = p_auction_header_id
2585: and pbhs.auction_header_id (+) = pah.auction_header_id
2586: and pbhs.bid_number (+) = p_bid_number
2587: and fl_bid.lookup_type(+) = 'PON_BID_STATUS'

Line 3212: fnd_lookup_values flv,

3208: pon_auction_headers_all pah,
3209: pon_price_elements pe,
3210: pon_price_element_types_tl pet,
3211: pon_auction_item_prices_all itm,
3212: fnd_lookup_values flv,
3213: fnd_lookup_values flv2,
3214: pon_pf_supplier_values pf_values,
3215: -- bidpdf: add bid value for cost factor
3216: pon_bid_price_elements pbpe

Line 3213: fnd_lookup_values flv2,

3209: pon_price_elements pe,
3210: pon_price_element_types_tl pet,
3211: pon_auction_item_prices_all itm,
3212: fnd_lookup_values flv,
3213: fnd_lookup_values flv2,
3214: pon_pf_supplier_values pf_values,
3215: -- bidpdf: add bid value for cost factor
3216: pon_bid_price_elements pbpe
3217: WHERE pah.auction_header_id = p_auction_header_id

Line 3941: fnd_lookup_values flv,

3937: pet.description,
3938: flv2.meaning pf_type_display
3939: FROM
3940: pon_price_element_types_tl pet,
3941: fnd_lookup_values flv,
3942: fnd_lookup_values flv2
3943: WHERE
3944: pet.language = l_printing_language
3945: AND pet.price_element_type_id = -10

Line 3942: fnd_lookup_values flv2

3938: flv2.meaning pf_type_display
3939: FROM
3940: pon_price_element_types_tl pet,
3941: fnd_lookup_values flv,
3942: fnd_lookup_values flv2
3943: WHERE
3944: pet.language = l_printing_language
3945: AND pet.price_element_type_id = -10
3946: AND flv.lookup_type = 'PON_PRICING_BASIS'