DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CS_STD

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

1502: CURSOR c1 IS
1503: SELECT 'X'
1504: FROM mtl_system_items_b mtl
1505: WHERE mtl.inventory_item_id = p_inventory_item_id
1506: AND mtl.organization_id = Cs_Std.get_item_valdn_orgzn_id;
1507: -- swai: forward port bug 2870951
1508: -- AND mtl.serviceable_product_flag = 'Y';
1509:
1510: l_dummy VARCHAR2(1);

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

1701: SELECT 'X'
1702: FROM aso_i_item_uoms_v uom
1703: WHERE uom.uom_code = p_unit_of_measure
1704: AND uom.inventory_item_id = p_inventory_item_id
1705: AND uom.organization_id = Cs_Std.get_item_valdn_orgzn_id;
1706:
1707: l_dummy VARCHAR2(1);
1708: l_valid VARCHAR2(1) := 'Y';
1709: