APPS.CSD_PROCESS_UTIL dependencies on CSD_PRODUCT_TRANSACTIONS

Line 4118: from csd_product_transactions

4114: BEGIN
4115:
4116: select 'X'
4117: into l_dummy
4118: from csd_product_transactions
4119: where product_transaction_id = p_prod_txn_id;
4120: RETURN TRUE;
4121: EXCEPTION
4122: When NO_DATA_FOUND then

Line 4149: csd_product_transactions b,

4145: a.repair_type_id,
4146: b.repair_line_id,
4147: c.quantity_required
4148: FROM csd_repairs a,
4149: csd_product_transactions b,
4150: cs_estimate_details c
4151: where a.repair_line_id = b.repair_line_id
4152: and b.estimate_detail_id = c.estimate_detail_id
4153: and b.product_transaction_id = p_prod_txn_id;

Line 4182: csd_product_transactions b,

4178: l_repair_type_id,
4179: l_repair_line_id,
4180: l_prod_txn_qty
4181: FROM csd_repairs a,
4182: csd_product_transactions b,
4183: cs_estimate_details c
4184: where a.repair_line_id = b.repair_line_id
4185: and b.estimate_detail_id = c.estimate_detail_id
4186: and b.product_transaction_id = p_prod_txn_id ;

Line 4297: FROM csd_product_transactions a,

4293:
4294: CURSOR qty_by_type IS
4295: SELECT
4296: abs(sum(b.quantity_required))
4297: FROM csd_product_transactions a,
4298: cs_estimate_details b
4299: where a.estimate_detail_id = b.estimate_detail_id
4300: and a.action_code = 'CUST_PROD'
4301: and a.prod_txn_status <> 'CANCELLED'