DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on MTL_SYSTEM_ITEMS

Line 1351: FROM MTL_SYSTEM_ITEMS

1347:
1348: -- Bug 4176961
1349: CURSOR c_primary_uom IS
1350: SELECT PRIMARY_UOM_CODE
1351: FROM MTL_SYSTEM_ITEMS
1352: WHERE INVENTORY_ITEM_ID = x_lines_rec.INVENTORY_ITEM_ID
1353: AND ORGANIZATION_ID = x_lines_rec.ship_from_org_id;
1354:
1355: BEGIN

Line 4398: FROM mtl_system_items

4394: v_ship_to_address_id NUMBER;
4395: --
4396: CURSOR c_CustOrderEnabled(p_InvItemId NUMBER, p_ShipFromOrgId NUMBER) IS
4397: SELECT customer_order_enabled_flag
4398: FROM mtl_system_items
4399: WHERE inventory_item_id = p_InvItemId AND
4400: organization_id = p_ShipFromOrgId;
4401: --
4402: BEGIN

Line 4645: FROM mtl_system_items

4641: BEGIN
4642: --
4643: SELECT inventory_item_id
4644: INTO v_InventoryItemIdFromSeg
4645: FROM mtl_system_items
4646: WHERE segment1 = x_lines_rec.inventory_item_segment1
4647: AND segment2 = x_lines_rec.inventory_item_segment2
4648: AND segment3 = x_lines_rec.inventory_item_segment3
4649: AND segment4 = x_lines_rec.inventory_item_segment4