eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_MASS_RCV_PVT dependencies on CS_ESTIMATE_DETAILS

Line 1135: FROM csd_product_transactions cpt, cs_estimate_details ced

1131: p_po_number VARCHAR2
1132: )
1133: IS
1134: SELECT ced.purchase_order_num
1135: FROM csd_product_transactions cpt, cs_estimate_details ced
1136: WHERE cpt.estimate_detail_id = ced.estimate_detail_id
1137: AND cpt.repair_line_id = p_repair_line_id
1138: AND ced.order_header_id = p_order_header_id
1139: AND ced.purchase_order_num = p_po_number;

Line 1146: cs_estimate_details ced

1142: IS
1143: SELECT MAX (ced.order_header_id)
1144: FROM csd_repairs cr,
1145: csd_product_transactions cpt,
1146: cs_estimate_details ced
1147: WHERE cr.incident_id = p_incident_id
1148: AND cpt.repair_line_id = cr.repair_line_id
1149: AND ced.estimate_detail_id = cpt.estimate_detail_id
1150: AND ced.order_header_id IS NOT NULL

Line 2692: FROM cs_estimate_details a

2688: --
2689: CURSOR cur_ord_details (p_est_detial_id NUMBER)
2690: IS
2691: SELECT a.order_header_id, a.order_line_id
2692: FROM cs_estimate_details a
2693: WHERE a.estimate_detail_id = p_est_detial_id
2694: AND a.order_header_id IS NOT NULL;
2695:
2696: CURSOR cur_ord_line (p_order_line_id NUMBER)