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.PO_GML_DB_COMMON dependencies on RCV_TRANSACTIONS

Line 398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;

394: dummy VARCHAR2(1000);
395: l_trans_opm_um VARCHAR2(25);
396: l_trans_opm_um2 VARCHAR2(25);
397:
398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;
399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;

Line 399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;

395: l_trans_opm_um VARCHAR2(25);
396: l_trans_opm_um2 VARCHAR2(25);
397:
398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;
399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;

Line 400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;

396: l_trans_opm_um2 VARCHAR2(25);
397:
398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;
399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;
404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;

Line 401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;

397:
398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;
399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;
404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;
405:

Line 402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;

398: l_trans_um rcv_transactions_interface.primary_unit_of_measure%TYPE;
399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;
404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;
405:
406: l_tran_row ic_tran_cmp%ROWTYPE;

Line 403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;

399: l_trans_um2 rcv_transactions_interface.primary_unit_of_measure%TYPE;
400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;
404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;
405:
406: l_tran_row ic_tran_cmp%ROWTYPE;
407: l_tran_rec gmi_trans_engine_pub.ictran_rec;

Line 404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;

400: l_src_doc_type rcv_transactions_interface.source_document_code%TYPE;
401: l_trx_type rcv_transactions_interface.transaction_type%TYPE;
402: l_destination_type_code rcv_transactions_interface.destination_type_code%TYPE;
403: l_req_line_id rcv_transactions_interface.requisition_line_id%TYPE;
404: l_receipt_source_code rcv_transactions_interface.receipt_source_code%TYPE;
405:
406: l_tran_row ic_tran_cmp%ROWTYPE;
407: l_tran_rec gmi_trans_engine_pub.ictran_rec;
408:

Line 517: l_validation_flag rcv_transactions_interface.validation_flag%TYPE ;

513: cr_intorg_tran_rec cr_intorg_tran%ROWTYPE;
514:
515: -- ROI enhancements bug# 3061052
516: -- create two new cursors for retreiving lot information.
517: l_validation_flag rcv_transactions_interface.validation_flag%TYPE ;
518:
519:
520: CURSOR cr_rcv_lots_interface IS
521: SELECT primary_quantity,

Line 561: From rcv_transactions

557:
558:
559: CURSOR Cur_Receipt_qty IS
560: Select QUANTITY, UNIT_OF_MEASURE
561: From rcv_transactions
562: where TRANSACTION_ID = l_parent_transaction_id;
563:
564:
565: CURSOR Cur_rcv_lot_txn(l_parent_transaction_id IN NUMBER, v_lot_num IN VARCHAR2, v_sublot_num IN VARCHAR2) IS

Line 670: FROM rcv_transactions_interface rti,

666: l_req_line_id,
667: l_receipt_source_code,
668: l_parent_transaction_id,
669: l_comments
670: FROM rcv_transactions_interface rti,
671: rcv_shipment_lines rsl
672: WHERE rti.shipment_line_id = rsl.shipment_line_id(+) and
673: rti.interface_transaction_id = p_interface_trx_id;
674:

Line 686: Check Receipt_qty = Return qty in same UM's in rcv_transactions

682: /*
683: IF (l_trx_type = 'RETURN TO VENDOR' or l_trx_type = 'RETURN TO RECEIVING')
684:
685: Check Profile OPtion GML Validate return
686: Check Receipt_qty = Return qty in same UM's in rcv_transactions
687: Check if rcv_Lots_interface records for return match with rcv_lot_transactions for receipt
688: then find ic_tran_pnd record for rcv_lots_interface for receipt and copy the quantitiy.
689:
690: If anything does not match do Nothing */

Line 731: from rcv_shipment_lines rs, rcv_transactions rt

727: BEGIN
728:
729: select rs.line_num
730: into l_line_num
731: from rcv_shipment_lines rs, rcv_transactions rt
732: where rt.interface_transaction_id = p_interface_trx_id
733: and rs.shipment_header_id = rt.shipment_header_id
734: and rs.shipment_line_id = rt.shipment_line_id
735: and rt.transaction_type IN('DELIVER','RETURN TO RECEIVING','CORRECT');

Line 885: --from rcv_Transactions_itnerface does not have time stamp

881: l_tran_rec.line_type := 0;
882: l_tran_rec.reason_code := NULL;
883:
884: --Bug 2407358 Trans date in ic_tran_pnd does not have time stamp since transaction_date
885: --from rcv_Transactions_itnerface does not have time stamp
886: --If the profile option GML: Use Creation Date as Transaction Date is set to Yes then
887: --see if the date part of the creation_date and transaction_date from RTI table are same
888: --if they are then use the creation_date which has the time stamp else use the transaction_date
889:

Line 1101: -- validation_flag is used to check the source of the data into rcv_transactions_interface

1097: -- ROI enhancements bug# 3061052
1098: -- use mtl_transaction_lots_temp instead of rcv_lots_interface for the ROI.
1099: -- From the applications(forms) lot data goes into rcv_lots_interface and mtl_transaction_lots_temp.
1100: -- From the ROI(starting from 11.5.10) lot data goes only into mtl_transaction_lots_temp.
1101: -- validation_flag is used to check the source of the data into rcv_transactions_interface
1102: -- if it is 'Y' it is coming from ROI(third party) else it is coming from the Receiving forms.
1103:
1104: IF l_validation_flag = 'Y' THEN
1105: OPEN cr_mtl_transaction_lots_temp ;

Line 1432: l_error_message := x_return_Status||' No data found in RCV_TRANSACTIONS_INTERFACE';

1428: CLOSE cr_rcv_lots_interface;
1429: END IF;
1430:
1431: IF x_return_status = '-5' THEN
1432: l_error_message := x_return_Status||' No data found in RCV_TRANSACTIONS_INTERFACE';
1433:
1434: ELSIF x_return_status = '-10' THEN
1435: l_error_message := x_return_Status||' No data found in IC_WHSE_MST for organization with id '||to_char(l_organization_id);
1436:

Line 1624: from rcv_transactions

1620:
1621: Cursor get_corr_qty( v_tran_id NUMBER) is
1622: Select transaction_type,
1623: secondary_quantity
1624: from rcv_transactions
1625: where parent_transaction_id = v_tran_id
1626: and transaction_type in ('CORRECT','RETURN TO RECEIVING') ;
1627:
1628: BEGIN

Line 1667: from rcv_transactions

1663:
1664: Cursor get_qty(v_transaction_id IN NUMBER) is
1665: select transaction_type,
1666: secondary_quantity
1667: from rcv_transactions
1668: where transaction_id = v_transaction_id;
1669:
1670: Cursor get_child_qty(v_p_transaction_id IN NUMBER) is
1671: select transaction_id,

Line 1674: from rcv_transactions

1670: Cursor get_child_qty(v_p_transaction_id IN NUMBER) is
1671: select transaction_id,
1672: transaction_type,
1673: secondary_quantity
1674: from rcv_transactions
1675: where parent_transaction_id = v_p_transaction_id;
1676:
1677: v_transaction_type VARCHAR2(100);
1678: v_final_qty NUMBER DEFAULT 0;