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.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_LOCATION_TREE

Line 468: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

464: CASE inv_mwb_globals.g_tree_node_type
465:
466: WHEN 'APPTREE_OBJECT_TRUNK' THEN
467:
468: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
469:
470: IF inv_mwb_globals.g_detailed = 1 THEN
471: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
472: 'moqd.subinventory_code';

Line 487: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

483: add_qf_where_onhand('ONHAND');
484:
485: WHEN 'ORG' THEN
486:
487: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
488:
489: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
490: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
491: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 499: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

495: add_qf_where_onhand('ONHAND');
496:
497: WHEN 'MATLOC' THEN
498:
499: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
500: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
501: 'moqd.subinventory_code';
502: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
503: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

Line 509: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

505: add_qf_where_onhand('ONHAND');
506:
507: WHEN 'SUB' THEN
508:
509: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
510:
511: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
512: 'moqd.subinventory_code';
513: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 528: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

524:
525: add_qf_where_onhand('ONHAND');
526:
527: WHEN 'LOC' THEN
528: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
529:
530: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
531: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
532: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

Line 654: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

650: inv_mwb_globals.g_tree_subinventory_code
651: );
652: END IF;
653:
654: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
655: inv_mwb_query_manager.add_where_clause(
656: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
657: 'ONHAND'
658: );

Line 687: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

683: );
684:
685: WHEN 'REV' THEN
686:
687: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
688: add_qf_where_onhand('ONHAND');
689:
690: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
691: 'moqd.subinventory_code';

Line 760: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

756:
757:
758: WHEN 'LPN' THEN
759:
760: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
761: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
762: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
763: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
764: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');

Line 788: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

784: add_qf_where_onhand('ONHAND');
785:
786: WHEN 'LOT' THEN
787:
788: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
789: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
790: 'moqd.revision';
791: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
792: 'moqd.subinventory_code';

Line 861: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');

857: add_qf_where_onhand('ONHAND');
858:
859: WHEN 'SERIAL' THEN
860: -- Dummy code
861: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
862: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND'); --Bug 7611434 click tree serial node will not show all items/qty
863: add_qf_where_onhand('ONHAND');
864: END CASE;
865: