APPS.CSD_DEPOT_UPDATE_PVT dependencies on CSD_PRODUCT_TRANSACTIONS

Line 1236: csd_product_transactions cpt,

1232: rcv.last_updated_by who_col,
1233: rcv.oe_order_header_id rma_header_id,
1234: rst.serial_num serial_number
1235: from csd_repairs cr,
1236: csd_product_transactions cpt,
1237: cs_estimate_details ced,
1238: rcv_transactions rcv,
1239: rcv_serial_transactions rst,
1240: oe_order_headers_all ooh,

Line 1456: Update csd_product_transactions

1452:
1453: END IF;
1454:
1455: -- Update the prod txns withe the status
1456: Update csd_product_transactions
1457: set prod_txn_status = 'RECEIVED'
1458: where product_transaction_id = C1.product_transaction_id;
1459:
1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');

Line 1660: csd_product_transactions cpt,

1656: dd.inventory_item_id ,
1657: dd.organization_id
1658: from
1659: csd_Repairs cra,
1660: csd_product_transactions cpt,
1661: cs_estimate_details ced,
1662: wsh_new_deliveries dl,
1663: wsh_delivery_assignments da,
1664: wsh_delivery_details dd ,

Line 1750: -- Update csd_product_transactions table with the status

1746: ro_txn_status = 'RO_SHIPPED'
1747: where repair_line_id = I.repair_line_id;
1748: END IF;
1749:
1750: -- Update csd_product_transactions table with the status
1751: update csd_product_transactions
1752: set prod_txn_status= 'SHIPPED'
1753: where product_transaction_id = I.product_transaction_id;
1754:

Line 1751: update csd_product_transactions

1747: where repair_line_id = I.repair_line_id;
1748: END IF;
1749:
1750: -- Update csd_product_transactions table with the status
1751: update csd_product_transactions
1752: set prod_txn_status= 'SHIPPED'
1753: where product_transaction_id = I.product_transaction_id;
1754:
1755: IF (g_debug > 0 ) THEN