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 1788: -- and organization_id = cs_std.get_item_valdn_orgzn_id

1784: -- select decode(item_cost,0 ,null,item_cost)
1785: -- into l_item_cost
1786: -- from cst_item_costs
1787: -- where inventory_item_id = x_estimate_line_rec.inventory_item_id
1788: -- and organization_id = cs_std.get_item_valdn_orgzn_id
1789: -- and cost_type_id = 1;
1790: --
1791: -- x_estimate_line_rec.item_cost := l_item_cost ;
1792: --

Line 5413: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id

5409: and WRK.work_entity_type_code = 'BOM'
5410: and SC.Service_code_Id = ROSC.Service_code_id
5411: and nvl(SC.active_from, SYSDATE) <= SYSDATE
5412: and nvl(SC.active_to, SYSDATE) >= SYSDATE
5413: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id
5414: -- and WRK.work_entity_id1 IS NOT NULL
5415: and BOM.bill_sequence_id = WRK.work_entity_id1
5416: and nvl(BOM.effectivity_date , SYSDATE) <= SYSDATE -- swai bug 3323274
5417: and nvl(BOM.disable_date , SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5466: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id

5462: and WRK.work_entity_type_code = 'BOM'
5463: and SC.Service_code_Id = ROSC.Service_code_id
5464: and nvl(SC.active_from, SYSDATE) <= SYSDATE
5465: and nvl(SC.active_to, SYSDATE) >= SYSDATE
5466: and WRK.work_entity_id3 = cs_std.get_item_valdn_orgzn_id
5467: -- and WRK.work_entity_id2 IS NOT NULL
5468: and OPSEQ.ROUTING_SEQUENCE_ID = WRK.work_entity_id2
5469: and nvl(OPSEQ.effectivity_date , SYSDATE) <= SYSDATE -- swai bug 3323274
5470: and nvl(OPSEQ.disable_date , SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5516: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id

5512: AND WRK.work_entity_type_code = 'BOM'
5513: AND SC.Service_code_Id = ROSC.Service_code_id
5514: AND NVL(SC.active_from, SYSDATE) <= SYSDATE
5515: AND NVL(SC.active_to, SYSDATE) >= SYSDATE
5516: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id
5517: -- and WRK.work_entity_id1 IS NOT NULL
5518: AND BOM.bill_sequence_id = WRK.work_entity_id1
5519: AND NVL(BOM.effectivity_date, SYSDATE) <= SYSDATE -- swai bug 3323274
5520: AND NVL(BOM.disable_date, SYSDATE) >= SYSDATE -- swai bug 3323274

Line 5568: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id

5564: AND WRK.work_entity_type_code = 'BOM'
5565: AND SC.Service_code_Id = ROSC.Service_code_id
5566: AND NVL(SC.active_from, SYSDATE) <= SYSDATE
5567: AND NVL(SC.active_to, SYSDATE) >= SYSDATE
5568: AND WRK.work_entity_id3 = Cs_Std.get_item_valdn_orgzn_id
5569: -- and WRK.work_entity_id2 IS NOT NULL
5570: AND OPSEQ.ROUTING_SEQUENCE_ID = WRK.work_entity_id2
5571: AND NVL(OPSEQ.effectivity_date, SYSDATE) <= SYSDATE -- swai bug 3323274
5572: AND NVL(OPSEQ.disable_date, SYSDATE) >= SYSDATE -- swai bug 3323274