DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on FND_LOOKUPS

Line 1167: fnd_lookups fl1,

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
1171: and pbp.auction_header_id = paha.auction_header_id

Line 1415: fnd_lookups fl1,

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
1419: and pbp.auction_header_id = paha.auction_header_id

Line 1635: fnd_lookups f1,

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
1637: where paha.auction_header_id = p_auction_header_id
1638: and petr.auction_header_id = paha.auction_header_id
1639: and petr.supplier_sequence = p_supplier_sequence

Line 2551: fnd_lookups fl,

2547: pah.NEGOTIATION_REQUESTER_ID
2548: ------------End: Added as part of bug 8771921 ---------------
2549: from
2550: pon_auction_headers_all pah ,
2551: fnd_lookups fl,
2552: fnd_lookups fl2,
2553: fnd_lookups flbr ,
2554: fnd_lookups fl_rank_ind,
2555: fnd_lookups fl_pf_type_allowed,

Line 2552: fnd_lookups fl2,

2548: ------------End: Added as part of bug 8771921 ---------------
2549: from
2550: pon_auction_headers_all pah ,
2551: fnd_lookups fl,
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 ,

Line 2553: fnd_lookups flbr ,

2549: from
2550: pon_auction_headers_all pah ,
2551: fnd_lookups fl,
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,

Line 2554: fnd_lookups fl_rank_ind,

2550: pon_auction_headers_all pah ,
2551: fnd_lookups fl,
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 ,

Line 2555: fnd_lookups fl_pf_type_allowed,

2551: fnd_lookups fl,
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 ,

Line 2572: fnd_lookups fl_security,

2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,
2571: fnd_territories_tl entity_terr,
2572: fnd_lookups fl_security,
2573: gl_daily_conversion_types gdct,
2574: fnd_product_groups fpg,
2575: pon_negotiation_styles_vl ns,
2576: PO_ALL_DOC_STYLE_LINES ps,

Line 3131: fnd_lookups attrGrpFlv

3127: order by pas.line_number,pas.attribute_sequence_number,pas.sequence_number) AS LINE_ATTRIBUTE_SCORES
3128: from
3129: pon_auction_attributes pal,
3130: pon_bid_attribute_values pbav,
3131: fnd_lookups attrGrpFlv
3132: where
3133: pal.auction_header_id = p_auction_header_id
3134: AND pal.line_number = line_num
3135: and pbav.auction_header_id(+) = pal.auction_header_id

Line 3527: FND_LOOKUPS flkp

3523: FND_USER U,
3524: PER_ALL_PEOPLE_F P,
3525: PER_ALL_ASSIGNMENTS_F A,
3526: PER_ALL_POSITIONS S,
3527: FND_LOOKUPS flkp
3528: WHERE PAH.auction_header_id = p_auction_header_id
3529: AND TM.AUCTION_HEADER_ID = pah.auction_header_id
3530: AND l_is_buyer_negpdf = 'Y'
3531: AND pah.neg_team_enabled_flag = 'Y'

Line 4027: fnd_lookups fl

4023: FROM
4024: pon_auction_headers_all pah,
4025: pon_price_elements ppe,
4026: pon_price_element_types_tl ppett,
4027: fnd_lookups fl
4028: WHERE pah.auction_header_id = p_auction_header_id
4029: and ppe.auction_header_id = pah.auction_header_id
4030: AND pah.large_neg_enabled_flag = 'N'
4031: AND l_is_buyer_negpdf = 'Y'

Line 4066: fnd_lookups lookuptable

4062: from
4063: pon_auction_headers_all pah,
4064: pon_large_neg_pf_values pon_large_neg_pf_values,
4065: pon_price_element_types_vl priceelementtypesvl,
4066: fnd_lookups lookuptable
4067: WHERE pah.auction_header_id = p_auction_header_id
4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
4069: and pah.large_neg_enabled_flag = 'Y'
4070: AND l_is_buyer_negpdf = 'Y'