DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on CS_STD

Line 620: l_inv_org NUMBER := cs_std.get_item_valdn_orgzn_id;

616: -- local variables
617:
618: l_operation_seq_num NUMBER := 1;
619: l_estimate_uom VARCHAR2(25);
620: l_inv_org NUMBER := cs_std.get_item_valdn_orgzn_id;
621: l_counter NUMBER;
622:
623: -- cursor to calculate the estimate details.
624:

Line 640: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND

636: SUM(crl.estimate_quantity) AS quantity
637: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi
638: WHERE crl.repair_line_id = p_rep_line_id AND
639: crl.inventory_item_id = msi.inventory_item_id AND
640: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND
641: billing_category = 'M' AND
642: est_line_source_type_code IN ('MANUAL','REPAIR_BOM')
643: GROUP BY crl.inventory_item_id,/*crl.estimate_quantity,*/ crl.lot_control_code,crl.serial_number_control_code,msi.primary_uom_code,crl.unit_of_measure_code,msi.revision_qty_control_code, msi.new_revision_code;
644: