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.BOM_DIAGUNITTEST_ITMHLCHK dependencies on MTL_PARAMETERS

Line 106: from mtl_parameters

102:
103: If l_org_id is not null Then /* validate if input org_id exists*/
104: Begin
105: select 1 into l_org_exists
106: from mtl_parameters
107: where organization_id = l_org_id;
108: Exception
109: When others Then
110: l_org_exists :=0;

Line 144: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||

140: sqltxt := 'SELECT mif.PADDED_ITEM_NUMBER "Item Number", '||
141: ' mp.organization_code "Org Code", '||
142: ' mif.inventory_item_id "Item Id", '||
143: ' mif.organization_id "Org Id" '||
144: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||
145: ' WHERE (mif.organization_id,PADDED_ITEM_NUMBER) in '||
146: ' (select organization_id , padded_item_number '||
147: ' from mtl_item_flexfields '||
148: ' group by organization_Id, PADDED_ITEM_NUMBER '||

Line 343: ' FROM gl_code_combinations_kfv glcc, mtl_item_flexfields mif , mtl_parameters mp '||

339: ' decode(mif.cost_of_sales_account,glcc.code_combination_Id,''X'') "Cost Of Sales Account", '||
340: ' decode(mif.sales_account,glcc.code_combination_Id,''X'') "Sales Account", '||
341: ' decode(mif.expense_account,glcc.code_combination_Id,''X'') "Expense Account", '||
342: ' decode(mif.encumbrance_account,glcc.code_combination_Id,''X'') "Encumbrance Account" '||
343: ' FROM gl_code_combinations_kfv glcc, mtl_item_flexfields mif , mtl_parameters mp '||
344: ' WHERE glcc.code_combination_id in (mif.cost_of_sales_account, mif.SALES_ACCOUNT, '||
345: ' mif.EXPENSE_ACCOUNT, mif.ENCUMBRANCE_ACCOUNT) '||
346: ' AND nvl(glcc.END_DATE_ACTIVE,sysdate) < sysdate '||
347: ' AND DETAIL_POSTING_ALLOWED = ''Y'' '||

Line 405: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||

401: sqltxt := 'SELECT mif.PADDED_ITEM_NUMBER "Item Number", '||
402: ' mp.Organization_code "Org Code", '||
403: ' mif.inventory_item_id "Item Id", '||
404: ' mif.organization_id "Org Id" '||
405: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||
406: ' WHERE Not Exists (SELECT ''x'' '||
407: ' FROM mtl_system_items_tl msitl '||
408: ' WHERE msitl.organization_id = mif.organization_id '||
409: ' AND msitl.inventory_item_id = mif.inventory_item_id) '||

Line 452: ' from mtl_item_flexfields mif, mtl_parameters mp '||

448: ' mif.costing_enabled_flag "COSTING ENABLED FLAG", '||
449: ' mif.inventory_asset_flag "INVENTORY ASSET FLAG", '||
450: ' mif.inventory_item_id "INVENTORY ITEM ID", '||
451: ' mp.organization_id "ORGANIZATION ID" '||
452: ' from mtl_item_flexfields mif, mtl_parameters mp '||
453: ' where mif.organization_id = mp.organization_id '||
454: ' and mif.costing_enabled_flag = ''Y'' '||
455: ' and not exists (select null '||
456: ' from cst_item_costs cic '||

Line 530: ' from mtl_item_flexfields mif, mtl_parameters mp '||

526: ' mif.ont_pricing_qty_source "ont pricing qty source", '||
527: ' mif.secondary_uom_code "secondary uom code", '||
528: ' mif.inventory_item_id "inventory item id", '||
529: ' mif.organization_id "organization id" '||
530: ' from mtl_item_flexfields mif, mtl_parameters mp '||
531: ' where mif.organization_id=mp.organization_id '||
532: ' and nvl(mif.tracking_quantity_ind,''P'') = ''P'' '||
533: ' and nvl(mif.ont_pricing_qty_source,''P'') = ''P'' '||
534: ' and mif.secondary_uom_code is not null ';

Line 591: ' from mtl_item_flexfields mif, mtl_parameters mp, po_agents_v pav '||

587: ' to_char(pav.end_date_active,''DD-MON-YYYY HH24:MI:SS'') "End Date Active", '||
588: ' mif.inventory_item_id "Inventory Item Id", '||
589: ' mif.organization_id "Organization Id", '||
590: ' mif.buyer_id "Default Buyer Id" '||
591: ' from mtl_item_flexfields mif, mtl_parameters mp, po_agents_v pav '||
592: ' where mif.organization_id=mp.organization_id '||
593: ' and mif.buyer_id=pav.agent_id '||
594: ' and sysdate not between nvl(pav.start_date_active, sysdate-1) '||
595: ' and nvl(pav.end_date_active, sysdate+1) ';

Line 654: ' from mtl_item_flexfields mif, mtl_parameters mp, mtl_planners mpl '||

650: ' mpl.planner_code "Planner", '||
651: ' to_char(mpl.disable_date,''DD-MON-YYYY HH24:MI:SS'') "Planner Disable Date", '||
652: ' mif.inventory_item_id "Inventory Item Id", '||
653: ' mif.organization_id "Organization Id" '||
654: ' from mtl_item_flexfields mif, mtl_parameters mp, mtl_planners mpl '||
655: ' where mif.organization_id=mp.organization_id '||
656: ' and mif.organization_id=mpl.organization_id '||
657: ' and mif.planner_code=mpl.planner_code '||
658: ' and nvl(mpl.disable_date, sysdate+1) < sysdate ';

Line 734: ' from mtl_item_flexfields mif, mtl_parameters mp '||

730: ' decode(build_in_wip_flag,inventory_item_flag,decode(build_in_wip_flag,decode(bom_item_type,1,''N'',2,''N'',3,''N'',5,''N'',build_in_wip_flag),null,build_in_wip_flag), '||
731: ' ''N'',decode(build_in_wip_flag,decode(bom_item_type,1,''N'',2,''N'',3,''N'',5,''N'',build_in_wip_flag),null,build_in_wip_flag),'||
732: ' ''Y'',build_in_wip_flag) "BUILD IN WIP FLAG", '||
733: ' mif.inventory_item_id "Inventory Item Id",mif.organization_id "Org Id" '||
734: ' from mtl_item_flexfields mif, mtl_parameters mp '||
735: ' where '||
736: ' mif.organization_id=mp.organization_id '||
737: ' and '||
738: ' ( '||

Line 917: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||

913: ' to_char(mif.start_date_active,''DD-MON-YYYY HH24:MI:SS'') "Start Date Active", '||
914: ' to_char(mif.end_date_active,''DD-MON-YYYY HH24:MI:SS'') "End Date Active", '||
915: ' mif.inventory_item_id "Item Id", '||
916: ' mp.organization_id "Org Id" '||
917: ' FROM mtl_item_flexfields mif , mtl_parameters mp '||
918: ' WHERE 1=1 '||
919: ' AND mif.organization_id=mp.organization_id '||
920: ' AND ( mif.end_date_active IS NOT NULL OR mif.start_date_active IS NOT NULL ) ';
921: