APPS.CSD_WIP_JOB_PVT dependencies on CSD_REPAIRS

Line 670: csd_repairs_v cr

666: cr.quantity,
667: -- cr.inventory_org_id bug#10144772
668: fnd_profile.value('CSD_DEF_REP_INV_ORG')
669: FROM
670: csd_repairs_v cr
671: WHERE
672: cr.repair_line_id = p_repair_line_id;
673:
674: BEGIN

Line 886: from csd_repairs

882:
883: CURSOR c_repair_line_info(p_repair_line_id IN NUMBER) IS
884: select inventory_item_id, unit_of_measure, quantity, serial_number
885: --, inventory_org_id -- swai: bug 9954780
886: from csd_repairs
887: where repair_line_id = p_repair_line_id;
888:
889: CURSOR c_count_material(p_wip_entity_id NUMBER, l_inventory_item_id NUMBER) IS
890: select 'X'

Line 1557: FROM csd_repairs cr,

1553: msi.revision_qty_control_code,
1554: msi.primary_uom_code,
1555: cr.quantity,
1556: cr.serial_number
1557: FROM csd_repairs cr,
1558: (SELECT * FROM TABLE(CAST(l_repair_line_ids AS JTF_NUMBER_TABLE))) ro_lines,
1559: csd_repair_job_xref crj,
1560: wip_discrete_jobs wdj,
1561: mtl_system_items_b msi,