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_INTERFACE

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