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_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 390: FROM pon_auction_item_prices_all itm,

386: -- unallocatedItems are items that have awarded bids that have yet to be
387: -- allocated
388: CURSOR unallocatedItems IS
389: SELECT distinct itm.line_number
390: FROM pon_auction_item_prices_all itm,
391: po_req_lines_in_pool_src_v prlv
392: WHERE itm.auction_header_id = p_auction_header_id AND
393: nvl(itm.line_origination_code, 'NONE') = 'REQUISITION' AND
394: nvl(itm.allocation_status, 'NO') <> 'ALLOCATED' AND

Line 405: FROM pon_auction_item_prices_all itm,

401: -- Allocation Failure notification, if line fails to be auto-allocated.
402: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_line_number NUMBER) IS
403: SELECT itm.document_disp_line_number, itm.item_number, itm.item_revision, itm.item_description,
404: itm.requisition_number, pjo.name
405: FROM pon_auction_item_prices_all itm,
406: per_jobs pjo
407: WHERE itm.auction_header_id = p_auction_header_id AND
408: itm.line_number = p_line_number AND
409: pjo.job_id (+) = itm.job_id;

Line 475: UPDATE pon_auction_item_prices_all

471: RETURN;
472: ELSE
473: -- update allocation status of item to allocated if allocation succeeded
474:
475: UPDATE pon_auction_item_prices_all
476: SET allocation_status = 'ALLOCATED'
477: WHERE auction_header_id = p_auction_header_id and
478: line_number = p_item_line_number;
479: END IF;

Line 545: pon_auction_item_prices_all paip

541: -- the alloc quantity
542: CURSOR reqRescheduledSingleSupplier IS
543: SELECT paa.orig_req_line_id, prlsv.requisition_quantity
544: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
545: pon_auction_item_prices_all paip
546: WHERE paa.allocated_qty > prlsv.requisition_quantity AND
547: paa.auction_header_id = p_auction_header_id AND
548: nvl(paa.split_req_line_id, -999)= -999 AND
549: nvl(paa.allocated_qty,0) > 0 AND

Line 564: pon_auction_item_prices_all paip

560: -- of mrp rescheduling
561: CURSOR reqRescheduledMultSupplier IS
562: SELECT paa.orig_req_line_id
563: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
564: pon_auction_item_prices_all paip
565: WHERE paa.auction_header_id = p_auction_header_id AND
566: nvl(paa.split_req_line_id, -999)= -999 AND
567: nvl(paa.allocated_qty,0) > 0 AND
568: prlsv.requisition_line_id = paa.orig_req_line_id AND

Line 582: FROM pon_auction_item_prices_all itm,

578: -- Allocation Failure notification, if line fails to be auto-allocated.
579: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_orig_req_line_id NUMBER) IS
580: SELECT distinct paa.bid_line_number, itm.item_number, itm.item_revision, itm.item_description,
581: itm.requisition_number, pjo.name
582: FROM pon_auction_item_prices_all itm,
583: per_jobs pjo,
584: pon_award_allocations paa
585: WHERE paa.auction_header_id = itm.auction_header_id AND
586: paa.bid_line_number = itm.line_number AND

Line 910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;

906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;
910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
911: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
912: l_contract_type pon_auction_headers_all.contract_type%TYPE;
913:
914:

Line 911: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;

907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;
910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
911: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
912: l_contract_type pon_auction_headers_all.contract_type%TYPE;
913:
914:
915: l_api_name VARCHAR2(30) := ' AUTO_REQ_ALLOCATION ';

Line 961: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah

957: l_bid_price_col := l_empty_table;
958:
959: SELECT paip.order_type_lookup_code, paip.purchase_basis, pah.contract_type
960: INTO l_order_type_lookup_code, l_purchase_basis, l_contract_type
961: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah
962: WHERE paip.auction_header_id = pah.auction_header_id
963: AND paip.auction_header_id = p_auctionid
964: AND paip.line_number = p_line_number;
965:

Line 988: FROM pon_auction_item_prices_all itm,

984: bl.award_quantity) quantity,
985: bh.bid_number,
986: bl.bid_currency_unit_price
987: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col
988: FROM pon_auction_item_prices_all itm,
989: pon_bid_item_prices bl,
990: pon_bid_headers bh,
991: pon_auction_headers_all pah
992: WHERE itm.auction_header_id = p_auctionID AND

Line 1547: FROM pon_auction_item_prices_all

1543: INTO x_requistion_based
1544: FROM DUAL
1545: WHERE EXISTS(
1546: SELECT '1'
1547: FROM pon_auction_item_prices_all
1548: WHERE auction_header_id = p_auction_header_id
1549: AND line_origination_code = 'REQUISITION'
1550: );
1551:

Line 1786: pon_auction_item_prices_all paip,

1782: ,'N') has_bid_payments_flag
1783: , pbip.award_shipment_number
1784:
1785: FROM
1786: pon_auction_item_prices_all paip,
1787: pon_bid_item_prices pbip,
1788: mtl_units_of_measure mtluom,
1789: pon_bid_headers pbh,
1790: fnd_currencies fc

Line 1818: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP

1814: up lines that have no allocations, but have backing requisitions to get a
1815: sum of 0 */
1816: CURSOR sumOfReqAllocQuantities is
1817: SELECT PAIP.line_number, nvl(sum(nvl(PAA.allocated_qty,0)), 0)
1818: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP
1819: WHERE PAIP.auction_header_id = p_auction_header_id
1820: AND PAIP.award_status = 'COMPLETED'
1821: AND nvl(PAIP.awarded_quantity,0) > 0
1822: AND PAA.auction_header_id(+) = PAIP.auction_header_id

Line 2060: check pon_auction_item_prices_all.order_type_lookup_code)

2056: item information from the negotiation line, and
2057: the requisiton_line_id and quantity
2058: (price and quantity will be switched when
2059: negotiation line is amount-based-
2060: check pon_auction_item_prices_all.order_type_lookup_code)
2061: from the backing requisition.
2062: */
2063:
2064:

Line 2509: pon_auction_item_prices_all paip,

2505: 1,'Y','N')
2506: ,'N') --Line_loc_populated
2507:
2508: FROM
2509: pon_auction_item_prices_all paip,
2510: pon_bid_item_prices pbip,
2511: mtl_units_of_measure mtluom,
2512: pon_bid_headers pbh,
2513: fnd_currencies fc,

Line 2644: FROM pon_auction_item_prices_all paip,

2640: x_user_id, -- last_updated_by
2641: sysdate, -- creation_date
2642: x_user_id -- created_by
2643:
2644: FROM pon_auction_item_prices_all paip,
2645: pon_bid_item_prices pbip,
2646: pon_bid_payments_shipments bpys,
2647: pon_auc_payments_shipments apys,
2648: po_lines_interface pli,

Line 2830: FROM pon_auction_item_prices_all paip,

2826: paip.job_id, -- job_id
2827: decode(paip.order_type_lookup_code,
2828: 'FIXED PRICE', round(pbip.bid_currency_unit_price, fc.precision),
2829: null) -- amount
2830: FROM pon_auction_item_prices_all paip,
2831: pon_bid_item_prices pbip,
2832: mtl_units_of_measure mtluom,
2833: pon_bid_headers pbh,
2834: fnd_currencies fc,

Line 2908: FROM pon_auction_item_prices_all paip,

2904: pbs.effective_start_date, -- effective_date
2905: pbs.effective_end_date, -- expiration_date
2906: pbs.auction_header_id, -- auction_header_id
2907: pbs.auction_line_number -- auction_line_number
2908: FROM pon_auction_item_prices_all paip,
2909: pon_bid_item_prices pbip,
2910: pon_bid_shipments pbs,
2911: po_lines_interface pli
2912: WHERE pbip.bid_number = p_bid_number and

Line 3169: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;

3165:
3166: l_cur_interface_line_id NUMBER;
3167: l_cur_attr_values_id NUMBER;
3168: l_cur_attr_values_tlp_id NUMBER;
3169: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;
3170: l_cur_ip_category_id NUMBER;
3171: l_cur_item_id NUMBER;
3172: l_cur_org_id NUMBER;
3173: l_language_code pon_auction_headers_all.language_code%TYPE;

Line 3198: pon_auction_item_prices_all paip,

3194: icx.stored_in_column,
3195: pbav.value,
3196: paa.attribute_name
3197: FROM pon_bid_item_prices pbip,
3198: pon_auction_item_prices_all paip,
3199: po_lines_interface pli,
3200: pon_bid_attribute_values pbav,
3201: pon_auction_attributes paa,
3202: icx_cat_agreement_attrs_v icx

Line 4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;

4506: x_number_of_failed_pos NUMBER;
4507: x_email_type VARCHAR2(240);
4508: x_allocation_error VARCHAR2(2000);
4509: x_line_number NUMBER;
4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;

Line 4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;

4507: x_email_type VARCHAR2(240);
4508: x_allocation_error VARCHAR2(2000);
4509: x_line_number NUMBER;
4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;
4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;

Line 4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;

4508: x_allocation_error VARCHAR2(2000);
4509: x_line_number NUMBER;
4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;
4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
4516: l_resultout VARCHAR2(10);

Line 4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;

4509: x_line_number NUMBER;
4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;
4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
4516: l_resultout VARCHAR2(10);
4517:

Line 4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;

4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;
4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
4516: l_resultout VARCHAR2(10);
4517:
4518: x_open_bidding_date date;
4519: x_close_bidding_date date;

Line 4605: FROM pon_auction_item_prices_all

4601: INTO x_requistion_based
4602: FROM DUAL
4603: WHERE EXISTS(
4604: SELECT '1'
4605: FROM pon_auction_item_prices_all
4606: WHERE auction_header_id = p_auction_header_id
4607: AND line_origination_code = 'REQUISITION'
4608: );
4609: