APPS.CSD_BULK_RECEIVE_PVT dependencies on CSD_PRODUCT_TRANSACTIONS

Line 102: from csd_product_transactions dpt,

98: select dpt.prod_txn_status,
99: edt.order_line_id,
100: edt.order_header_id,
101: dpt.source_serial_number
102: from csd_product_transactions dpt,
103: cs_estimate_details edt
104: where dpt.repair_line_id = p_repair_line_id
105: and dpt.action_type = 'RMA'
106: and dpt.prod_txn_status = 'BOOKED'

Line 1142: -- update the csd_product_transactions table to mark it as unplanned.

1138:
1139: raise fnd_api.g_exc_error;
1140: end if;
1141:
1142: -- update the csd_product_transactions table to mark it as unplanned.
1143:
1144: update csd_product_transactions
1145: set unplanned_receipt_flag = 'Y'
1146: where repair_line_id = bk_rcv_rec.repair_line_id

Line 1144: update csd_product_transactions

1140: end if;
1141:
1142: -- update the csd_product_transactions table to mark it as unplanned.
1143:
1144: update csd_product_transactions
1145: set unplanned_receipt_flag = 'Y'
1146: where repair_line_id = bk_rcv_rec.repair_line_id
1147: and action_type = 'RMA';
1148: -- no matching RO's found, create new RO and product lines.

Line 1234: from csd_product_transactions cpt,

1230: -- get the order header and line id for the RMA just created.
1231: begin
1232: select ced.order_header_id,ced.order_line_id
1233: into bk_rcv_rec.order_header_id,bk_rcv_rec.order_line_id
1234: from csd_product_transactions cpt,
1235: cs_estimate_details ced
1236: where cpt.repair_line_id = l_repair_line_id
1237: and ced.estimate_detail_id = cpt.estimate_detail_id
1238: and cpt.action_type = 'RMA';

Line 1269: update csd_product_transactions

1265: l_bulk_autorcv_tbl(l_counter).rcv_attribute13 := bk_rcv_rec.rcv_attribute13;
1266: l_bulk_autorcv_tbl(l_counter).rcv_attribute14 := bk_rcv_rec.rcv_attribute14;
1267: l_bulk_autorcv_tbl(l_counter).rcv_attribute15 := bk_rcv_rec.rcv_attribute15;
1268: -- update product transactions and mark it as unplanned.
1269: update csd_product_transactions
1270: set unplanned_receipt_flag = 'Y'
1271: where repair_line_id = l_repair_line_id
1272: and action_type = 'RMA';
1273:

Line 1552: update csd_product_transactions

1548: p_msg_data => l_msg_data);
1549:
1550: -- 12.1.2 BR ER FP changes subhat
1551: if NVL(FND_PROFILE.value('CSD_MATCH_SR_RO_RMA_FOR_BLKRCV'),'Y') = 'Y' then
1552: update csd_product_transactions
1553: set unplanned_receipt_flag = 'Y'
1554: where repair_line_id = l_repair_line_id
1555: and action_type = 'RMA';
1556: end if;