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.PO_THIRD_PARTY_STOCK_GRP dependencies on MTL_SYSTEM_ITEMS

Line 118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;

114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;

Line 119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;

115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;

Line 120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;

116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;

Line 121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;

117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;

Line 122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;

118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;

Line 123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;

119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;
127: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;

Line 124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;

120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;
127: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
128: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;

Line 125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;

121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;
122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;
127: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
128: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;
129:

Line 126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;

122: l_base MTL_SYSTEM_ITEMS.BASE_ITEM_ID%TYPE;
123: l_eam MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE%TYPE;
124: l_asset MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
125: l_transactable MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
126: l_stockable MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG%TYPE;
127: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
128: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;
129:
130:

Line 228: FROM MTL_SYSTEM_ITEMS msi

224: l_eam ,
225: l_asset ,
226: l_transactable,
227: l_stockable
228: FROM MTL_SYSTEM_ITEMS msi
229: -- INVCONV IC_WHSE_MST imst
230: WHERE -- INVCONV msi.organization_id = imst.mtl_organization_id (+)
231: msi.inventory_item_id = p_inventory_item_id
232: AND msi.organization_id = p_inventory_org_id ;

Line 465: mtl_system_items msi

461: hr_organization_units hou ,
462: hr_organization_information hoi ,
463: mtl_parameters mp ,
464: hr_organization_information hoi2 ,
465: mtl_system_items msi
466: -- INVCONV ic_whse_mst imst
467: where HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
468: and HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
469: and HOI.ORG_INFORMATION_CONTEXT||'' ='Accounting Information'

Line 1318: FROM mtl_system_items_b

1314: -- End API initialization
1315:
1316: SELECT NVL(inventory_asset_flag, 'N')
1317: INTO x_inventory_asset_flag
1318: FROM mtl_system_items_b
1319: WHERE inventory_item_id = p_inventory_item_id
1320: AND organization_id = p_organization_id;
1321:
1322: FND_MSG_PUB.Count_And_Get

Line 1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;

1611: l_consigned_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%TYPE;
1612: l_msg_data VARCHAR2(2000);
1613: l_return_status VARCHAR2(1);
1614: l_msg_count NUMBER;
1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;
1616: l_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%TYPE;
1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;
1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;
1619: --

Line 1809: l_item_inv_asset_flag mtl_system_items_b.inventory_asset_flag%TYPE := 'N';

1805: x_consigned_from_supplier_flag OUT NOCOPY VARCHAR2)IS
1806: l_return_status varchar2(1) := NULL;
1807: l_msg_count number := NULL;
1808: l_msg_data varchar2(2000) := NULL;
1809: l_item_inv_asset_flag mtl_system_items_b.inventory_asset_flag%TYPE := 'N';
1810: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE := NULL;
1811: l_last_billing_date date := NULL;
1812: l_consigned_billing_cycle number := NULL;
1813: l_module_name CONSTANT VARCHAR2(100) := 'IS_ASL_CONSIGNED_FROM_SUPPLIER';