APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_MFG_PART_NUMBERS_ALL_V

Line 3778: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V

3774:
3775: SELECT MFG_PART_NUM
3776: INTO l_manufacturer_part_num
3777: FROM(
3778: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V
3779: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3780: AND ORGANIZATION_ID = p_master_organization_id
3781: ORDER BY ROW_ID
3782: ) WHERE ROWNUM =1;

Line 4174: FROM MTL_MFG_PART_NUMBERS_ALL_V

4170: SELECT MFG_PART_NUM, MANUFACTURER_NAME
4171: INTO l_manufacturer_part_num, l_manufacturer
4172: FROM(
4173: SELECT MFG_PART_NUM,MANUFACTURER_NAME
4174: FROM MTL_MFG_PART_NUMBERS_ALL_V
4175: WHERE INVENTORY_ITEM_ID =p_inventory_item_id
4176: AND ORGANIZATION_ID = p_master_organization_id
4177: ORDER BY ROW_ID ) WHERE ROWNUM =1;
4178:

Line 6328: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V

6324: Begin
6325: SELECT MANUFACTURER_NAME
6326: INTO l_manufacturer
6327: FROM(
6328: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V
6329: WHERE INVENTORY_ITEM_ID =p_inventory_item_id
6330: AND ORGANIZATION_ID = p_master_organization_id
6331: ORDER BY ROW_ID ) WHERE ROWNUM =1;
6332: EXCEPTION

Line 6518: FROM mtl_mfg_part_numbers_all_v WHERE row_id =

6514: MANUFACTURER_ID
6515: INTO p_manufacturer_part_num,
6516: p_manufacturer,
6517: p_manufacturer_id
6518: FROM mtl_mfg_part_numbers_all_v WHERE row_id =
6519: (SELECT Min(row_id)
6520: FROM mtl_mfg_part_numbers_all_v
6521: WHERE inventory_item_id = p_inventory_item_id
6522: AND organization_id = l_master_organization_id);

Line 6520: FROM mtl_mfg_part_numbers_all_v

6516: p_manufacturer,
6517: p_manufacturer_id
6518: FROM mtl_mfg_part_numbers_all_v WHERE row_id =
6519: (SELECT Min(row_id)
6520: FROM mtl_mfg_part_numbers_all_v
6521: WHERE inventory_item_id = p_inventory_item_id
6522: AND organization_id = l_master_organization_id);
6523:
6524: