DBA Data[Home] [Help]

APPS.CSD_DEPOT_UPDATE_PVT dependencies on CSD_REPAIR_HISTORY

Line 1260: FROM csd_Repair_history crh,

1256: and rcv.transaction_type = 'DELIVER'
1257: and rcv.source_document_code = 'RMA'
1258: and rcv.transaction_id NOT IN
1259: (SELECT paramn1
1260: FROM csd_Repair_history crh,
1261: csd_repairs cra
1262: WHERE crh.repair_line_id = cra.repair_line_id
1263: AND crh.event_code = 'RR'
1264: AND cra.repair_group_id = p_rep_group_id );

Line 1681: from csd_Repair_history

1677: and dd.source_line_id = ced.order_line_id
1678: and dd.released_status = 'C'
1679: and dd.delivery_detail_id not in
1680: (select paramn1
1681: from csd_Repair_history
1682: where repair_line_id = cra.repair_line_id
1683: and event_code='PS')
1684: and mtlu.uom_code = dd.requested_quantity_uom;
1685: