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.

[Home] [Help]

APPS.PON_UNSOL_CREATE_PO_PKG dependencies on PON_AWARD_ALLOCATIONS

Line 104: Decode('Y', (SELECT is_linked_pr_line_yn FROM pon_award_allocations paa

100: p_document_number, -- document_number
101: pbip.line_number, -- auction_line_number,
102: pbip.bid_number, -- bid_number
103: pbip.line_number, -- bid_line_number
104: Decode('Y', (SELECT is_linked_pr_line_yn FROM pon_award_allocations paa
105: WHERE paa.bid_number = pbip.bid_number AND paa.bid_line_number = pbip.line_number AND paa.is_linked_pr_line_yn = 'Y' AND ROWNUM <2),
106: 'S', 'N'), -- orig_from_req_flag
107: --pbip.job_id, -- job_id
108: decode(pbip.order_type_lookup_code,'FIXED PRICE', pbip.bid_currency_unit_price, TO_NUMBER(NULL)) -- amount