DBA Data[Home] [Help]

APPS.CSD_COST_ANALYSIS_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 66: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt

62: IS
63: SELECT btc.billing_category,
64: sum(rel.item_Cost * ed.quantity_required) TotalCost -- sangita
65: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
66: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
67: WHERE rel.repair_estimate_id = p_repair_estimate_id
68: AND rel.estimate_detail_id = ed.estimate_detail_id
69: AND ed.txn_billing_type_id = btt.txn_billing_type_id
70: AND btc.billing_type = btt.billing_type

Line 366: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt

362: IS
363: SELECT btc.billing_category,
364: sum(nvl(ed.after_warranty_cost, 0)) TotalCharges
365: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
366: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
367: WHERE rel.repair_estimate_id = p_repair_estimate_id
368: AND rel.estimate_detail_id = ed.estimate_detail_id
369: AND ed.txn_billing_type_id = btt.txn_billing_type_id
370: AND btc.billing_type = btt.billing_type