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 PON_BIDDING_PARTIES

Line 840: FROM pon_bidding_parties pbp

836: OPEN xml_query_cursor FOR
837: SELECT pah.AUCTION_HEADER_ID AS NEGOTIATION_NUMBER,
838: pah.AUCTION_TITLE AS NEGOTIATION_TITLE,
839: (SELECT COUNT(*)
840: FROM pon_bidding_parties pbp
841: WHERE pbp.AUCTION_HEADER_ID = pah.AUCTION_HEADER_ID
842: ) AS NUMBER_OF_SUPPLIERS,
843: pah.CLOSE_BIDDING_DATE AS NEGOTIATION_CLOSE_DATE, --Modify by Chaoqun 04-Mar-2009
844: pah.CURRENCY_CODE as EMD_QUOTE_CURRENCY,

Line 950: FROM PON_bidding_parties pbp,

946: 'Y', 'EXEMPTED'),
947: pet.status_lookup_code)
948: ) as EMD_CURRENT_STATUS,
949: pet.Justification as EMD_JUSTIFICATION
950: FROM PON_bidding_parties pbp,
951: PON_EMD_TRANSACTIONS pet
952: WHERE pbp.AUCTION_HEADER_ID = p_auction_header_id
953: AND pbp.AUCTION_HEADER_ID = pet.AUCTION_HEADER_ID(+) --Modify by Chaoqun 05-Mar-2009
954: AND pbp.sequence = pet.supplier_sequence(+)

Line 1063: pon_bidding_parties pbp

1059: 'Y', 'EXEMPTED'),
1060: petr.status_lookup_code)
1061: into l_emd_current_status
1062: from pon_emd_transactions petr,
1063: pon_bidding_parties pbp
1064: where pbp.sequence=p_supplier_sequence
1065: and pbp.auction_header_id= p_auction_header_id
1066: and petr.auction_header_id(+) = pbp.auction_header_id
1067: and petr.supplier_sequence(+) = pbp.sequence

Line 1165: pon_bidding_parties pbp,

1161: )
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

Line 1356: pon_bidding_parties pbp,

1352: null) as EMD_FORFEIT_JUSTIFICATION,
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

Line 1413: pon_bidding_parties pbp,

1409: and application_id = 396
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

Line 1631: pon_bidding_parties pbp,

1627: and application_id = 396
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,

Line 2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr

2023: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
2024: SELECT pvsa.address_line1,pvsa.address_line2,pvsa.address_line3,pvsa.city,pvsa.state,pvsa.zip,pvsa.country, nvl(entity_terr.territory_short_name,pvsa.country),
2025: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name
2026: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country,l_contact_details_name
2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
2028: WHERE
2029: pah.auction_header_id = p_auction_header_id
2030: AND pvsa.org_id = pah.org_id
2031: AND PURCHASING_SITE_FLAG = 'Y'

Line 2075: FROM pon_bidding_parties

2071: OR p_requested_supplier_id IS NOT NULL) THEN
2072: BEGIN
2073: SELECT sequence
2074: INTO l_supplier_sequence_number
2075: FROM pon_bidding_parties
2076: WHERE
2077: auction_header_id = p_auction_header_id
2078: AND ((trading_partner_id = l_trading_partner_id AND
2079: vendor_site_id = p_vendor_site_id) OR

Line 2874: from pon_bidding_parties bp

2870: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
2871: and (l_is_buyer_negpdf IN (SELECT 'Y' FROM dual)
2872: or
2873: (not exists (select 'x'
2874: from pon_bidding_parties bp
2875: where bp.auction_header_id = paip.auction_header_id
2876: and ((bp.trading_partner_id = l_trading_partner_id
2877: and bp.vendor_site_id = p_vendor_site_id)
2878: OR bp.requested_supplier_id = p_requested_supplier_id)

Line 3754: pon_bidding_parties pbp,

3750: to_char((Nvl(pah.emd_amount,0) * pbp.rate),'FM999G999G999G999G999G999G999G999G999G999D00') emd_resp_curr_amount,
3751: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
3752: FROM
3753: pon_auction_headers_all pah,
3754: pon_bidding_parties pbp,
3755: fnd_currencies_tl ftl
3756: WHERE pah.auction_header_id = p_auction_header_id
3757: AND pbp.auction_header_id = pah.auction_header_id
3758: AND (l_is_buyer_negpdf = 'N')

Line 3909: FROM pon_bidding_parties pbp

3905: pbp.auction_header_id,
3906: pbp.trading_partner_id,
3907: pbp.trading_partner_contact_id,
3908: pbp.sequence
3909: FROM pon_bidding_parties pbp
3910: WHERE
3911: pbp.auction_header_id = p_auction_header_id
3912: AND l_is_buyer_negpdf = 'Y'
3913: ORDER BY sequence ASC;