eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_STD

Line 1777: -- and organization_id = cs_std.get_item_valdn_orgzn_id

1773: -- select decode(item_cost,0 ,null,item_cost)
1774: -- into l_item_cost
1775: -- from cst_item_costs
1776: -- where inventory_item_id = x_estimate_line_rec.inventory_item_id
1777: -- and organization_id = cs_std.get_item_valdn_orgzn_id
1778: -- and cost_type_id = 1;
1779: --
1780: -- x_estimate_line_rec.item_cost := l_item_cost ;
1781: --

Line 5379: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id

5375: and WRK.work_entity_type_code = 'BOM'
5376: and SC.Service_code_Id = ROSC.Service_code_id
5377: and nvl(SC.active_from, SYSDATE) <= SYSDATE
5378: and nvl(SC.active_to, SYSDATE) >= SYSDATE
5379: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id
5380: -- and WRK.work_entity_id1 IS NOT NULL
5381: and BOM.bill_sequence_id = WRK.work_entity_id1
5382: and nvl(BOM.effectivity_date , SYSDATE) <= SYSDATE -- swai bug 3323274
5383: and nvl(BOM.disable_date , SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5432: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id

5428: and WRK.work_entity_type_code = 'BOM'
5429: and SC.Service_code_Id = ROSC.Service_code_id
5430: and nvl(SC.active_from, SYSDATE) <= SYSDATE
5431: and nvl(SC.active_to, SYSDATE) >= SYSDATE
5432: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id
5433: -- and WRK.work_entity_id2 IS NOT NULL
5434: and OPSEQ.ROUTING_SEQUENCE_ID = WRK.work_entity_id2
5435: and nvl(OPSEQ.effectivity_date , SYSDATE) <= SYSDATE -- swai bug 3323274
5436: and nvl(OPSEQ.disable_date , SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5482: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id

5478: AND WRK.work_entity_type_code = 'BOM'
5479: AND SC.Service_code_Id = ROSC.Service_code_id
5480: AND NVL(SC.active_from, SYSDATE) <= SYSDATE
5481: AND NVL(SC.active_to, SYSDATE) >= SYSDATE
5482: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id
5483: -- and WRK.work_entity_id1 IS NOT NULL
5484: AND BOM.bill_sequence_id = WRK.work_entity_id1
5485: AND NVL(BOM.effectivity_date, SYSDATE) <= SYSDATE -- swai bug 3323274
5486: AND NVL(BOM.disable_date, SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5534: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id

5530: AND WRK.work_entity_type_code = 'BOM'
5531: AND SC.Service_code_Id = ROSC.Service_code_id
5532: AND NVL(SC.active_from, SYSDATE) <= SYSDATE
5533: AND NVL(SC.active_to, SYSDATE) >= SYSDATE
5534: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id
5535: -- and WRK.work_entity_id2 IS NOT NULL
5536: AND OPSEQ.ROUTING_SEQUENCE_ID = WRK.work_entity_id2
5537: AND NVL(OPSEQ.effectivity_date, SYSDATE) <= SYSDATE -- swai bug 3323274
5538: AND NVL(OPSEQ.disable_date, SYSDATE) >= SYSDATE -- swai bug 3323274