DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on CS_STD

Line 625: l_inv_org NUMBER := fnd_profile.value('CSD_DEF_REP_INV_ORG'); --cs_std.get_item_valdn_orgzn_id; bug#10144772, subhat

621: -- local variables
622:
623: l_operation_seq_num NUMBER := 1;
624: l_estimate_uom VARCHAR2(25);
625: l_inv_org NUMBER := fnd_profile.value('CSD_DEF_REP_INV_ORG'); --cs_std.get_item_valdn_orgzn_id; bug#10144772, subhat
626: l_counter NUMBER;
627:
628: -- cursor to calculate the estimate details.
629:

Line 645: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND

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
647: est_line_source_type_code IN ('MANUAL','REPAIR_BOM')
648: 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;
649: