DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CS_STD

Line 1212: AND mtl.organization_id = Cs_Std.get_item_valdn_orgzn_id;

1208: CURSOR c1 IS
1209: SELECT 'X'
1210: FROM mtl_system_items_b mtl
1211: WHERE mtl.inventory_item_id = p_inventory_item_id
1212: AND mtl.organization_id = Cs_Std.get_item_valdn_orgzn_id;
1213: -- swai: forward port bug 2870951
1214: -- AND mtl.serviceable_product_flag = 'Y';
1215:
1216: l_dummy VARCHAR2(1);

Line 1398: AND uom.organization_id = Cs_Std.get_item_valdn_orgzn_id;

1394: SELECT 'X'
1395: FROM aso_i_item_uoms_v uom
1396: WHERE uom.uom_code = p_unit_of_measure
1397: AND uom.inventory_item_id = p_inventory_item_id
1398: AND uom.organization_id = Cs_Std.get_item_valdn_orgzn_id;
1399:
1400: l_dummy VARCHAR2(1);
1401: l_valid VARCHAR2(1) := 'Y';
1402: