APPS.CSD_PROCESS_UTIL dependencies on CSD_PRODUCT_TRANSACTIONS

Line 4376: from csd_product_transactions

4372: BEGIN
4373:
4374: select 'X'
4375: into l_dummy
4376: from csd_product_transactions
4377: where product_transaction_id = p_prod_txn_id;
4378: RETURN TRUE;
4379: EXCEPTION
4380: When NO_DATA_FOUND then

Line 4407: csd_product_transactions b,

4403: a.repair_type_id,
4404: b.repair_line_id,
4405: c.quantity_required
4406: FROM csd_repairs a,
4407: csd_product_transactions b,
4408: cs_estimate_details c
4409: where a.repair_line_id = b.repair_line_id
4410: and b.estimate_detail_id = c.estimate_detail_id
4411: and b.product_transaction_id = p_prod_txn_id;

Line 4440: csd_product_transactions b,

4436: l_repair_type_id,
4437: l_repair_line_id,
4438: l_prod_txn_qty
4439: FROM csd_repairs a,
4440: csd_product_transactions b,
4441: cs_estimate_details c
4442: where a.repair_line_id = b.repair_line_id
4443: and b.estimate_detail_id = c.estimate_detail_id
4444: and b.product_transaction_id = p_prod_txn_id ;

Line 4555: FROM csd_product_transactions a,

4551:
4552: CURSOR qty_by_type IS
4553: SELECT
4554: abs(sum(b.quantity_required))
4555: FROM csd_product_transactions a,
4556: cs_estimate_details b
4557: where a.estimate_detail_id = b.estimate_detail_id
4558: and a.action_code = 'CUST_PROD'
4559: and a.prod_txn_status <> 'CANCELLED'