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.CSD_LOGISTICS_UTIL dependencies on CSD_PRODUCT_TRANSACTIONS

Line 2112: FROM CSD_PRODUCT_TRANSACTIONS

2108: book_sales_order_flag,
2109: release_sales_order_flag,
2110: ship_sales_order_flag,
2111: object_version_number
2112: FROM CSD_PRODUCT_TRANSACTIONS
2113: WHERE product_transaction_id = p_prod_txn_id;
2114:
2115: x_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
2116:

Line 2205: -- Validate the prod_txn_id if it exists in csd_product_transactions

2201:
2202: l_repair_line_id := p_product_txn_rec.repair_line_id;
2203: l_est_detail_id := p_product_txn_rec.estimate_detail_id;
2204:
2205: -- Validate the prod_txn_id if it exists in csd_product_transactions
2206: IF NOT
2207: (Csd_Process_Util.Validate_prod_txn_id(p_prod_txn_id => p_product_txn_rec.product_transaction_id))
2208: THEN
2209: RAISE Fnd_Api.G_EXC_ERROR;

Line 2519: Debug('Call csd_product_transactions_pkg.update_row to update the prod txn',

2515: END IF;
2516:
2517: END IF;
2518:
2519: Debug('Call csd_product_transactions_pkg.update_row to update the prod txn',
2520: l_mod_name,
2521: C_STATEMENT_LEVEL);
2522:
2523: Debug('estimate_details_id =['||l_est_detail_id||']',

Line 2528: Csd_Product_Transactions_Pkg.UPDATE_ROW(p_PRODUCT_TRANSACTION_ID => p_product_txn_rec.PRODUCT_TRANSACTION_ID,

2524: l_mod_name,
2525: C_STATEMENT_LEVEL);
2526:
2527:
2528: Csd_Product_Transactions_Pkg.UPDATE_ROW(p_PRODUCT_TRANSACTION_ID => p_product_txn_rec.PRODUCT_TRANSACTION_ID,
2529: p_REPAIR_LINE_ID => l_REPAIR_LINE_ID,
2530: p_ESTIMATE_DETAIL_ID => l_est_detail_id,
2531: p_ACTION_TYPE => p_product_txn_rec.ACTION_TYPE,
2532: p_ACTION_CODE => p_product_txn_rec.ACTION_CODE,

Line 2795: UPDATE CSD_PRODUCT_TRANSACTIONS

2791: p_product_txn_rec.PRODUCT_TRANSACTION_ID,
2792: l_mod_name,
2793: 1);
2794:
2795: UPDATE CSD_PRODUCT_TRANSACTIONS
2796: SET prod_txn_status = 'SUBMITTED',
2797: interface_to_om_flag = 'Y'
2798: WHERE product_transaction_id =
2799: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3172: -- UPDATE csd_product_transactions

3168: Debug('Update the prod txn status to BOOKED',
3169: l_mod_name,
3170: 1);
3171:
3172: -- UPDATE csd_product_transactions
3173: -- SET prod_txn_status = 'BOOKED',
3174: -- book_sales_order_flag = 'Y'
3175: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3176: -- IF SQL%NOTFOUND then

Line 3208: -- UPDATE csd_product_transactions

3204: Debug('Update the prod txn status to BOOKED',
3205: l_mod_name,
3206: 1);
3207:
3208: -- UPDATE csd_product_transactions
3209: -- SET prod_txn_status = 'BOOKED',
3210: -- book_sales_order_flag = 'Y'
3211: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3212: -- IF SQL%NOTFOUND then

Line 3603: UPDATE CSD_PRODUCT_TRANSACTIONS

3599:
3600: IF (p_product_txn_rec.ACTION_TYPE IN
3601: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3602: THEN
3603: UPDATE CSD_PRODUCT_TRANSACTIONS
3604: SET prod_txn_status = 'RELEASED',
3605: release_sales_order_flag = 'Y'
3606: WHERE product_transaction_id =
3607: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3696: CSD_PRODUCT_TRANSACTIONS c

3692: px_order_rec.serial_number,
3693: px_order_rec.shipped_quantity
3694: FROM oe_order_lines_all a,
3695: cs_estimate_details b,
3696: CSD_PRODUCT_TRANSACTIONS c
3697: WHERE a.line_id = b.order_line_id
3698: AND b.estimate_detail_id = c.estimate_detail_id
3699: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3700: EXCEPTION

Line 3789: UPDATE CSD_PRODUCT_TRANSACTIONS

3785:
3786: IF (p_product_txn_rec.ACTION_TYPE IN
3787: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3788: THEN
3789: UPDATE CSD_PRODUCT_TRANSACTIONS
3790: SET prod_txn_status = 'SHIPPED',
3791: ship_sales_order_flag = 'Y'
3792: WHERE product_transaction_id =
3793: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3825: UPDATE CSD_PRODUCT_TRANSACTIONS

3821:
3822: IF (p_product_txn_rec.ACTION_TYPE IN
3823: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3824: THEN
3825: UPDATE CSD_PRODUCT_TRANSACTIONS
3826: SET prod_txn_status = 'SHIPPED',
3827: ship_sales_order_flag = 'Y'
3828: WHERE product_transaction_id =
3829: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3861: UPDATE CSD_PRODUCT_TRANSACTIONS

3857:
3858: IF (p_product_txn_rec.ACTION_TYPE IN
3859: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3860: THEN
3861: UPDATE CSD_PRODUCT_TRANSACTIONS
3862: SET prod_txn_status = 'BOOKED',
3863: book_sales_order_flag = 'Y'
3864: WHERE product_transaction_id =
3865: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 4040: UPDATE CSD_PRODUCT_TRANSACTIONS

4036: END IF;
4037:
4038: --Update the product transactions table with the cancelled status.
4039: --
4040: UPDATE CSD_PRODUCT_TRANSACTIONS
4041: SET prod_txn_status = 'CANCELLED',
4042: LAST_UPDATE_DATE = SYSDATE,
4043: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4044: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,