APPS.CSD_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS

Line 642: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi

638: crl.unit_of_measure_code,
639: msi.revision_qty_control_code,
640: msi.new_revision_code,
641: SUM(crl.estimate_quantity) AS quantity
642: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi
643: WHERE crl.repair_line_id = p_rep_line_id AND
644: crl.inventory_item_id = msi.inventory_item_id AND
645: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND
646: billing_category = 'M' AND

Line 905: FROM mtl_system_items

901: p_item_id NUMBER
902: )
903: IS
904: SELECT serial_number_control_code
905: FROM mtl_system_items
906: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
907:
908:
909: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is

Line 1561: mtl_system_items_b msi,

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,
1562: wip_entities we
1563: WHERE crj.repair_line_id = ro_lines.column_value
1564: AND wdj.primary_item_id = crj.inventory_item_id
1565: AND crj.job_name = we.wip_entity_name