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 1141: FROM csd_product_transactions cpt, cs_estimate_details ced

1137: p_po_number VARCHAR2
1138: )
1139: IS
1140: SELECT ced.purchase_order_num
1141: FROM csd_product_transactions cpt, cs_estimate_details ced
1142: WHERE cpt.estimate_detail_id = ced.estimate_detail_id
1143: AND cpt.repair_line_id = p_repair_line_id
1144: AND ced.order_header_id = p_order_header_id
1145: AND ced.purchase_order_num = p_po_number;

Line 1152: cs_estimate_details ced

1148: IS
1149: SELECT MAX (ced.order_header_id)
1150: FROM csd_repairs cr,
1151: csd_product_transactions cpt,
1152: cs_estimate_details ced
1153: WHERE cr.incident_id = p_incident_id
1154: AND cpt.repair_line_id = cr.repair_line_id
1155: AND ced.estimate_detail_id = cpt.estimate_detail_id
1156: AND ced.order_header_id IS NOT NULL

Line 2709: FROM cs_estimate_details a

2705: --
2706: CURSOR cur_ord_details (p_est_detial_id NUMBER)
2707: IS
2708: SELECT a.order_header_id, a.order_line_id
2709: FROM cs_estimate_details a
2710: WHERE a.estimate_detail_id = p_est_detial_id
2711: AND a.order_header_id IS NOT NULL;
2712:
2713: CURSOR cur_ord_line (p_order_line_id NUMBER)