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 MTL_TRANSACTION_LOTS_TEMP

Line 530: CURSOR cr_mtl_transaction_lots_temp IS

526: reason_code
527: FROM rcv_lots_interface
528: WHERE interface_transaction_id = p_interface_trx_id ;
529:
530: CURSOR cr_mtl_transaction_lots_temp IS
531: SELECT primary_quantity,
532: transaction_quantity quantity,
533: secondary_quantity,
534: lot_number lot_num,

Line 537: FROM mtl_transaction_lots_temp

533: secondary_quantity,
534: lot_number lot_num,
535: sublot_num,
536: reason_code
537: FROM mtl_transaction_lots_temp
538: WHERE product_transaction_id = p_interface_trx_id
539: AND product_code = 'RCV' ;
540:
541: l_lot_attributes_rec cr_rcv_lots_interface%ROWTYPE ;

Line 1098: -- use mtl_transaction_lots_temp instead of rcv_lots_interface for the ROI.

1094: l_negate_lot_qty := 1;
1095: END IF;
1096:
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.

Line 1099: -- From the applications(forms) lot data goes into rcv_lots_interface and mtl_transaction_lots_temp.

1095: END IF;
1096:
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:

Line 1100: -- From the ROI(starting from 11.5.10) lot data goes only into mtl_transaction_lots_temp.

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

Line 1105: OPEN cr_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 ;
1106: ELSE
1107: OPEN cr_rcv_lots_interface ;
1108: END IF;
1109:

Line 1112: FETCH cr_mtl_transaction_lots_temp INTO l_lot_attributes_rec;

1108: END IF;
1109:
1110: LOOP
1111: IF l_validation_flag = 'Y' THEN
1112: FETCH cr_mtl_transaction_lots_temp INTO l_lot_attributes_rec;
1113: IF cr_mtl_transaction_lots_temp%NOTFOUND THEN
1114: CLOSE cr_mtl_transaction_lots_temp;
1115: EXIT ;
1116: END IF;

Line 1113: IF cr_mtl_transaction_lots_temp%NOTFOUND THEN

1109:
1110: LOOP
1111: IF l_validation_flag = 'Y' THEN
1112: FETCH cr_mtl_transaction_lots_temp INTO l_lot_attributes_rec;
1113: IF cr_mtl_transaction_lots_temp%NOTFOUND THEN
1114: CLOSE cr_mtl_transaction_lots_temp;
1115: EXIT ;
1116: END IF;
1117: ELSE

Line 1114: CLOSE cr_mtl_transaction_lots_temp;

1110: LOOP
1111: IF l_validation_flag = 'Y' THEN
1112: FETCH cr_mtl_transaction_lots_temp INTO l_lot_attributes_rec;
1113: IF cr_mtl_transaction_lots_temp%NOTFOUND THEN
1114: CLOSE cr_mtl_transaction_lots_temp;
1115: EXIT ;
1116: END IF;
1117: ELSE
1118: FETCH cr_rcv_lots_interface INTO l_lot_attributes_rec;

Line 1423: IF cr_mtl_transaction_lots_temp%ISOPEN THEN

1419: EXCEPTION
1420: WHEN ex_exception_found THEN
1421:
1422: -- ROI enhancements bug# 3061052
1423: IF cr_mtl_transaction_lots_temp%ISOPEN THEN
1424: CLOSE cr_mtl_transaction_lots_temp;
1425: END IF;
1426:
1427: IF cr_rcv_lots_interface%ISOPEN THEN

Line 1424: CLOSE cr_mtl_transaction_lots_temp;

1420: WHEN ex_exception_found THEN
1421:
1422: -- ROI enhancements bug# 3061052
1423: IF cr_mtl_transaction_lots_temp%ISOPEN THEN
1424: CLOSE cr_mtl_transaction_lots_temp;
1425: END IF;
1426:
1427: IF cr_rcv_lots_interface%ISOPEN THEN
1428: CLOSE cr_rcv_lots_interface;

Line 1576: IF cr_mtl_transaction_lots_temp%ISOPEN THEN

1572: x_return_status := SQLERRM;
1573: l_error_message := '-140 '||x_return_Status||' when others in PO_GML_DB_COMMON.CREATE_INV_TRANS_OPM';
1574:
1575: -- ROI enhancements bug# 3061052
1576: IF cr_mtl_transaction_lots_temp%ISOPEN THEN
1577: CLOSE cr_mtl_transaction_lots_temp;
1578: END IF;
1579:
1580: IF cr_rcv_lots_interface%ISOPEN THEN

Line 1577: CLOSE cr_mtl_transaction_lots_temp;

1573: l_error_message := '-140 '||x_return_Status||' when others in PO_GML_DB_COMMON.CREATE_INV_TRANS_OPM';
1574:
1575: -- ROI enhancements bug# 3061052
1576: IF cr_mtl_transaction_lots_temp%ISOPEN THEN
1577: CLOSE cr_mtl_transaction_lots_temp;
1578: END IF;
1579:
1580: IF cr_rcv_lots_interface%ISOPEN THEN
1581: CLOSE cr_rcv_lots_interface;