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 IC_TRAN_PND

Line 409: l_whse_code ic_tran_pnd.whse_code%TYPE;

405:
406: l_tran_row ic_tran_cmp%ROWTYPE;
407: l_tran_rec gmi_trans_engine_pub.ictran_rec;
408:
409: l_whse_code ic_tran_pnd.whse_code%TYPE;
410: l_orgn_code ic_tran_pnd.orgn_code%TYPE;
411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;

Line 410: l_orgn_code ic_tran_pnd.orgn_code%TYPE;

406: l_tran_row ic_tran_cmp%ROWTYPE;
407: l_tran_rec gmi_trans_engine_pub.ictran_rec;
408:
409: l_whse_code ic_tran_pnd.whse_code%TYPE;
410: l_orgn_code ic_tran_pnd.orgn_code%TYPE;
411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;

Line 414: l_co_code ic_tran_pnd.co_code%TYPE;

410: l_orgn_code ic_tran_pnd.orgn_code%TYPE;
411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;

Line 415: l_item_id ic_tran_pnd.item_id%TYPE;

411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;

Line 416: l_lot_status ic_tran_pnd.lot_status%TYPE;

412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;

Line 417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;

413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;

Line 418: l_location ic_tran_pnd.location%TYPE;

414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;
422: l_lot_no ic_lots_mst.lot_no%TYPE;

Line 419: l_user_id ic_tran_pnd.created_by%TYPE;

415: l_item_id ic_tran_pnd.item_id%TYPE;
416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;
422: l_lot_no ic_lots_mst.lot_no%TYPE;
423: l_sublot_no ic_lots_mst.sublot_no%TYPE;

Line 420: l_doc_type ic_tran_pnd.doc_type%TYPE;

416: l_lot_status ic_tran_pnd.lot_status%TYPE;
417: l_qc_grade ic_tran_pnd.qc_grade%TYPE := NULL;
418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;
422: l_lot_no ic_lots_mst.lot_no%TYPE;
423: l_sublot_no ic_lots_mst.sublot_no%TYPE;
424: ex_exception_found EXCEPTION;

Line 507: FROM ic_tran_pnd

503: MVT_STAT_STATUS ,
504: MOVEMENT_ID ,
505: LINE_DETAIL_ID ,
506: INVOICED_FLAG
507: FROM ic_tran_pnd
508: WHERE doc_type = 'OMSO'
509: AND line_id = l_oe_line_id
510: AND line_detail_id = l_oe_line_detail_id
511: AND COMPLETED_IND = 1;

Line 574: FROM IC_TRAN_PND

570: and SUBLOT_NUM = v_sublot_num;
571:
572: CURSOR Cur_opm_txn(l_line_id IN NUMBER, v_item_id IN NUMBER, v_lot_id IN NUMBER) IS
573: SELECT trans_qty, trans_qty2
574: FROM IC_TRAN_PND
575: where doc_type = 'PORC'
576: and line_id = l_line_id
577: and delete_mark = 0
578: and completed_ind = 1

Line 688: then find ic_tran_pnd record for rcv_lots_interface for receipt and copy the quantitiy.

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 */
691:
692: IF (NVL(fnd_profile.value('GML_VAL_RET_CORR_LOT_QTY'), 'Y') = 'N') AND

Line 884: --Bug 2407358 Trans date in ic_tran_pnd does not have time stamp since transaction_date

880: l_tran_rec.doc_line := l_line_num;
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

Line 1074: p_table_name => 'IC_TRAN_PND');

1070: x_tran_row => l_tran_row,
1071: x_return_status => l_return_status,
1072: x_msg_count => l_msg_count,
1073: x_msg_data => l_msg_data,
1074: p_table_name => 'IC_TRAN_PND');
1075:
1076:
1077:
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1086: RETURN; /Transactions created in ic_tran_pnd for Direct Shipment and so return from here/

1082:
1083: --every thing is successful then return 1
1084: x_return_status := '1';
1085:
1086: RETURN; /*Transactions created in ic_tran_pnd for Direct Shipment and so return from here*/
1087:
1088: END IF; /*l_trx_type = 'SHIP' and l_auto_transact_code = 'DELIVER'*/
1089:
1090: /* Now create the completed transaction */

Line 1370: p_table_name => 'IC_TRAN_PND');

1366: x_tran_row => l_tran_row,
1367: x_return_status => l_return_status,
1368: x_msg_count => l_msg_count,
1369: x_msg_data => l_msg_data,
1370: p_table_name => 'IC_TRAN_PND');
1371:
1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: x_return_status := '-110';
1374: raise ex_exception_found;

Line 1390: p_table_name => 'IC_TRAN_PND');

1386: x_tran_row => l_tran_row,
1387: x_return_status => l_return_status,
1388: x_msg_count => l_msg_count,
1389: x_msg_data => l_msg_data,
1390: p_table_name => 'IC_TRAN_PND');
1391:
1392:
1393:
1394:

Line 1569: 'IC_TRAN_PND' );

1565: l_request_id,
1566: l_program_application_id,
1567: l_program_id,
1568: sysdate,
1569: 'IC_TRAN_PND' );
1570:
1571: WHEN OTHERS 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';

Line 1597: 'IC_TRAN_PND' );

1593: l_request_id,
1594: l_program_application_id,
1595: l_program_id,
1596: sysdate,
1597: 'IC_TRAN_PND' );
1598:
1599: END CREATE_INV_TRANS_OPM;
1600:
1601: