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_QUERY_MANAGER

Line 1: PACKAGE BODY INV_MWB_QUERY_MANAGER AS

1: PACKAGE BODY INV_MWB_QUERY_MANAGER AS
2: /* $Header: INVMWQMB.pls 120.71.12010000.5 2008/11/14 12:57:39 vijrajen ship $ */
3:
4: TYPE DateBindRec IS RECORD(bind_name VARCHAR2(50), bind_value DATE);
5: TYPE VarcharBindRec IS RECORD(bind_name VARCHAR2(50), bind_value VARCHAR2(255));

Line 20: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_QUERY_MANAGER';

16: g_date_bind_index PLS_INTEGER;
17: g_varchar_bind_index PLS_INTEGER;
18: g_number_bind_index PLS_INTEGER;
19:
20: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_QUERY_MANAGER';
21:
22: g_initialize BOOLEAN;
23:
24: g_onhand_where_index PLS_INTEGER;

Line 436: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

432:
433: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
434:
435: IF inv_mwb_globals.g_detailed = 1 THEN
436: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
437: 'moqd.subinventory_code';
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
439: 'moqd.locator_id';
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

Line 438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

434:
435: IF inv_mwb_globals.g_detailed = 1 THEN
436: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
437: 'moqd.subinventory_code';
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
439: 'moqd.locator_id';
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
441: 'moqd.revision';
442:

Line 440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

436: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
437: 'moqd.subinventory_code';
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
439: 'moqd.locator_id';
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
441: 'moqd.revision';
442:
443: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
444: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 443: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

439: 'moqd.locator_id';
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
441: 'moqd.revision';
442:
443: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
444: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
445: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
446: END IF;
447:

Line 444: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
441: 'moqd.revision';
442:
443: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
444: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
445: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
446: END IF;
447:
448: add_qf_where_onhand('ONHAND');

Line 445: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

441: 'moqd.revision';
442:
443: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
444: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
445: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
446: END IF;
447:
448: add_qf_where_onhand('ONHAND');
449:

Line 454: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

450: WHEN 'ORG' THEN
451:
452: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
453:
454: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
455: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
456: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
457: 'moqd.subinventory_code';
458: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

Line 455: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

451:
452: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
453:
454: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
455: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
456: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
457: 'moqd.subinventory_code';
458: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
459:

Line 456: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

452: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
453:
454: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
455: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
456: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
457: 'moqd.subinventory_code';
458: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
459:
460: add_qf_where_onhand('ONHAND');

Line 458: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

454: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
455: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
456: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
457: 'moqd.subinventory_code';
458: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
459:
460: add_qf_where_onhand('ONHAND');
461:
462: WHEN 'MATLOC' THEN

Line 465: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

461:
462: WHEN 'MATLOC' THEN
463:
464: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
465: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
466: 'moqd.subinventory_code';
467: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
468: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
469: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 467: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

463:
464: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
465: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
466: 'moqd.subinventory_code';
467: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
468: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
469: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
470: add_qf_where_onhand('ONHAND');
471:

Line 468: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

464: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
465: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
466: 'moqd.subinventory_code';
467: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
468: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
469: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
470: add_qf_where_onhand('ONHAND');
471:
472: WHEN 'SUB' THEN

Line 469: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

465: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
466: 'moqd.subinventory_code';
467: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
468: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
469: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
470: add_qf_where_onhand('ONHAND');
471:
472: WHEN 'SUB' THEN
473:

Line 476: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

472: WHEN 'SUB' THEN
473:
474: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
475:
476: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
477: 'moqd.subinventory_code';
478: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
479: 'moqd.locator_id';
480:

Line 478: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

474: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
475:
476: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
477: 'moqd.subinventory_code';
478: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
479: 'moqd.locator_id';
480:
481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

477: 'moqd.subinventory_code';
478: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
479: 'moqd.locator_id';
480:
481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
483:
484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

Line 482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

478: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
479: 'moqd.locator_id';
480:
481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
483:
484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
486:

Line 484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

480:
481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
483:
484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
486:
487: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
488: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

Line 485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

481: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
482: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
483:
484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
486:
487: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
488: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
489:

Line 487: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

483:
484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
486:
487: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
488: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
489:
490: add_qf_where_onhand('ONHAND');
491:

Line 488: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

484: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
485: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
486:
487: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
488: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
489:
490: add_qf_where_onhand('ONHAND');
491:
492: WHEN 'LOC' THEN

Line 495: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

491:
492: WHEN 'LOC' THEN
493: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
494:
495: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

492: WHEN 'LOC' THEN
493: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
494:
495: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

Line 497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

493: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
494:
495: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

Line 499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

495: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
502:
503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

496: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
502:
503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
504: 'moqd.subinventory_code';

Line 501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

497: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
498:
499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
502:
503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
504: 'moqd.subinventory_code';
505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

499: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
500: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
502:
503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
504: 'moqd.subinventory_code';
505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
506: 'moqd.locator_id';
507: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

501: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
502:
503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
504: 'moqd.subinventory_code';
505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
506: 'moqd.locator_id';
507: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
508: 'moqd.lpn_id';
509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 507: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

503: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
504: 'moqd.subinventory_code';
505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
506: 'moqd.locator_id';
507: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
508: 'moqd.lpn_id';
509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
510: 'moqd.cost_group_id';
511:

Line 509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

505: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
506: 'moqd.locator_id';
507: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
508: 'moqd.lpn_id';
509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
510: 'moqd.cost_group_id';
511:
512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

508: 'moqd.lpn_id';
509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
510: 'moqd.cost_group_id';
511:
512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
514: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
515: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
516:

Line 513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

509: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
510: 'moqd.cost_group_id';
511:
512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
514: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
515: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
516:
517: add_qf_where_onhand('ONHAND');

Line 514: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

510: 'moqd.cost_group_id';
511:
512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
514: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
515: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
516:
517: add_qf_where_onhand('ONHAND');
518:

Line 515: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

511:
512: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
513: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
514: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
515: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
516:
517: add_qf_where_onhand('ONHAND');
518:
519: WHEN 'ITEM' THEN

Line 530: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

526: FROM mtl_system_items
527: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
528: AND organization_id = inv_mwb_globals.g_tree_organization_id;
529:
530: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
531: 'moqd.cost_group_id';
532: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
533: 'moqd.subinventory_code';
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 532: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

528: AND organization_id = inv_mwb_globals.g_tree_organization_id;
529:
530: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
531: 'moqd.cost_group_id';
532: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
533: 'moqd.subinventory_code';
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
535: 'moqd.locator_id';
536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

530: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
531: 'moqd.cost_group_id';
532: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
533: 'moqd.subinventory_code';
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
535: 'moqd.locator_id';
536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
537: 'moqd.lpn_id';
538:

Line 536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

532: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
533: 'moqd.subinventory_code';
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
535: 'moqd.locator_id';
536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
537: 'moqd.lpn_id';
538:
539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

535: 'moqd.locator_id';
536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
537: 'moqd.lpn_id';
538:
539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
541: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
543:

Line 540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

536: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
537: 'moqd.lpn_id';
538:
539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
541: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
543:
544: -- Onhand Material Status Support

Line 541: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

537: 'moqd.lpn_id';
538:
539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
541: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
543:
544: -- Onhand Material Status Support
545: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.

Line 542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

538:
539: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
540: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
541: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
543:
544: -- Onhand Material Status Support
545: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
546: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 561: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

557: end if;
558: end if;
559:
560: if (l_default_status_id is not null and l_serial_controlled = 0 and l_lot_controlled = 0) then
561: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
562: 'moqd.status_id';
563: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
564: end if;
565: -- End Onhand Material Status Support

Line 563: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');

559:
560: if (l_default_status_id is not null and l_serial_controlled = 0 and l_lot_controlled = 0) then
561: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
562: 'moqd.status_id';
563: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
564: end if;
565: -- End Onhand Material Status Support
566:
567: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

Line 568: inv_mwb_query_manager.add_where_clause(

564: end if;
565: -- End Onhand Material Status Support
566:
567: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
568: inv_mwb_query_manager.add_where_clause(
569: 'moqd.lpn_id = :onh_tree_lpn_id' ,
570: 'ONHAND'
571: );
572: ELSE

Line 573: inv_mwb_query_manager.add_where_clause(

569: 'moqd.lpn_id = :onh_tree_lpn_id' ,
570: 'ONHAND'
571: );
572: ELSE
573: inv_mwb_query_manager.add_where_clause(
574: 'moqd.lpn_id IS NULL' ,
575: 'ONHAND'
576: );
577: END IF;

Line 580: inv_mwb_query_manager.add_where_clause(

576: );
577: END IF;
578:
579: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
580: inv_mwb_query_manager.add_where_clause(
581: 'moqd.locator_id = :onh_tree_loc_id' ,
582: 'ONHAND'
583: );
584: ELSE

Line 585: inv_mwb_query_manager.add_where_clause(

581: 'moqd.locator_id = :onh_tree_loc_id' ,
582: 'ONHAND'
583: );
584: ELSE
585: inv_mwb_query_manager.add_where_clause(
586: 'moqd.locator_id IS NULL' ,
587: 'ONHAND'
588: );
589: END IF;

Line 592: inv_mwb_query_manager.add_where_clause(

588: );
589: END IF;
590:
591: IF inv_mwb_globals.g_tree_subinventory_code IS NOT NULL THEN
592: inv_mwb_query_manager.add_where_clause(
593: 'moqd.subinventory_code = :onh_tree_sub_code' ,
594: 'ONHAND'
595: );
596: END IF;

Line 599: inv_mwb_query_manager.add_bind_variable(

595: );
596: END IF;
597:
598: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
599: inv_mwb_query_manager.add_bind_variable(
600: 'onh_tree_lpn_id',
601: inv_mwb_globals.g_tree_parent_lpn_id
602: );
603: END IF;

Line 606: inv_mwb_query_manager.add_bind_variable(

602: );
603: END IF;
604:
605: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
606: inv_mwb_query_manager.add_bind_variable(
607: 'onh_tree_loc_id',
608: inv_mwb_globals.g_tree_loc_id
609: );
610: END IF;

Line 613: inv_mwb_query_manager.add_bind_variable(

609: );
610: END IF;
611:
612: IF inv_mwb_globals.g_tree_subinventory_code IS NOT NULL THEN
613: inv_mwb_query_manager.add_bind_variable(
614: 'onh_tree_sub_code',
615: inv_mwb_globals.g_tree_subinventory_code
616: );
617: END IF;

Line 620: inv_mwb_query_manager.add_where_clause(

616: );
617: END IF;
618:
619: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
620: inv_mwb_query_manager.add_where_clause(
621: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
622: 'ONHAND'
623: );
624: inv_mwb_query_manager.add_where_clause(

Line 624: inv_mwb_query_manager.add_where_clause(

620: inv_mwb_query_manager.add_where_clause(
621: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
622: 'ONHAND'
623: );
624: inv_mwb_query_manager.add_where_clause(
625: 'moqd.organization_id = :onh_tree_organization_id' ,
626: 'ONHAND'
627: );
628:

Line 630: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

626: 'ONHAND'
627: );
628:
629: IF l_rev_control = 2 THEN
630: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
631: 'moqd.revision';
632: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
633: END IF;
634:

Line 632: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

628:
629: IF l_rev_control = 2 THEN
630: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
631: 'moqd.revision';
632: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
633: END IF;
634:
635: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
636: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 636: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

632: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
633: END IF;
634:
635: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
636: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
637: 'moqd.lot_number';
638: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
639: END IF;
640: add_qf_where_onhand('ONHAND');

Line 638: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

634:
635: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
636: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
637: 'moqd.lot_number';
638: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
639: END IF;
640: add_qf_where_onhand('ONHAND');
641: inv_mwb_query_manager.add_bind_variable(
642: 'onh_tree_organization_id',

Line 641: inv_mwb_query_manager.add_bind_variable(

637: 'moqd.lot_number';
638: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
639: END IF;
640: add_qf_where_onhand('ONHAND');
641: inv_mwb_query_manager.add_bind_variable(
642: 'onh_tree_organization_id',
643: inv_mwb_globals.g_tree_organization_id
644: );
645: inv_mwb_query_manager.add_bind_variable(

Line 645: inv_mwb_query_manager.add_bind_variable(

641: inv_mwb_query_manager.add_bind_variable(
642: 'onh_tree_organization_id',
643: inv_mwb_globals.g_tree_organization_id
644: );
645: inv_mwb_query_manager.add_bind_variable(
646: 'onh_tree_inventory_item_id',
647: inv_mwb_globals.g_tree_item_id
648: );
649:

Line 655: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

651:
652: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
653: add_qf_where_onhand('ONHAND');
654:
655: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
656: 'moqd.subinventory_code';
657: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
658: 'moqd.locator_id';
659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 657: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

653: add_qf_where_onhand('ONHAND');
654:
655: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
656: 'moqd.subinventory_code';
657: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
658: 'moqd.locator_id';
659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
660: 'moqd.lot_number';
661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

655: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
656: 'moqd.subinventory_code';
657: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
658: 'moqd.locator_id';
659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
660: 'moqd.lot_number';
661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
662: 'moqd.cost_group_id';
663: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

657: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
658: 'moqd.locator_id';
659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
660: 'moqd.lot_number';
661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
662: 'moqd.cost_group_id';
663: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
664: 'moqd.lpn_id';
665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

Line 663: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

659: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
660: 'moqd.lot_number';
661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
662: 'moqd.cost_group_id';
663: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
664: 'moqd.lpn_id';
665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
666: 'moqd.revision';
667:

Line 665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

661: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
662: 'moqd.cost_group_id';
663: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
664: 'moqd.lpn_id';
665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
666: 'moqd.revision';
667:
668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

664: 'moqd.lpn_id';
665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
666: 'moqd.revision';
667:
668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

Line 669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

665: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
666: 'moqd.revision';
667:
668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

Line 670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

666: 'moqd.revision';
667:
668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
674:

Line 671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

667:
668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
674:
675: -- Onhand Material Status Support

Line 672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

668: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
674:
675: -- Onhand Material Status Support
676: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.

Line 673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

669: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
670: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
671: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
672: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
674:
675: -- Onhand Material Status Support
676: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
677: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

688: end if;
689: end if;
690:
691: if (l_default_status_id is not null and l_serial_controlled = 0 and l_lot_controlled = 0) then
692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
693: 'moqd.status_id';
694: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
695: end if;
696: -- End Onhand Material Status Support

Line 694: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');

690:
691: if (l_default_status_id is not null and l_serial_controlled = 0 and l_lot_controlled = 0) then
692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
693: 'moqd.status_id';
694: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
695: end if;
696: -- End Onhand Material Status Support
697:
698: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

Line 699: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');

695: end if;
696: -- End Onhand Material Status Support
697:
698: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
699: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
700: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
701: ELSE
702: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
703: END IF;

Line 700: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

696: -- End Onhand Material Status Support
697:
698: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
699: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
700: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
701: ELSE
702: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
703: END IF;
704:

Line 702: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');

698: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
699: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
700: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
701: ELSE
702: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
703: END IF;
704:
705: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
706: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

Line 706: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

702: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
703: END IF;
704:
705: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
706: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
707: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
708: ELSE
709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
710: END IF;

Line 707: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

703: END IF;
704:
705: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
706: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
707: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
708: ELSE
709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
710: END IF;
711:

Line 709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');

705: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
706: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
707: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
708: ELSE
709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
710: END IF;
711:
712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

Line 712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

708: ELSE
709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
710: END IF;
711:
712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:

Line 713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

709: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
710: END IF;
711:
712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');

710: END IF;
711:
712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

Line 715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

711:
712: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);

Line 717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

713: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);
720: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
721:

Line 718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

714: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_item_id' ,'ONHAND');
715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);
720: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
721:
722:

Line 719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);

715: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);
720: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
721:
722:
723: WHEN 'LPN' THEN

Line 720: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

716:
717: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
718: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
719: inv_mwb_query_manager.add_bind_variable('onh_tree_item_id', inv_mwb_globals.g_tree_item_id);
720: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
721:
722:
723: WHEN 'LPN' THEN
724:

Line 726: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');

722:
723: WHEN 'LPN' THEN
724:
725: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
726: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:

Line 727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

723: WHEN 'LPN' THEN
724:
725: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
726: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

724:
725: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
726: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

Line 729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');

725: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
726: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id', 'ONHAND');
727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

Line 731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

727: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

728: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';

Line 733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

729: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';
737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

730:
731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';
737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
738: 'moqd.locator_id';

Line 735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

731: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
732: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';
737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
738: 'moqd.locator_id';
739: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

733: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
734: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';
737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
738: 'moqd.locator_id';
739: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
740: 'moqd.lpn_id';
741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 739: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

735: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
736: 'moqd.subinventory_code';
737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
738: 'moqd.locator_id';
739: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
740: 'moqd.lpn_id';
741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
742: 'moqd.cost_group_id';
743:

Line 741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

737: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
738: 'moqd.locator_id';
739: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
740: 'moqd.lpn_id';
741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
742: 'moqd.cost_group_id';
743:
744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

740: 'moqd.lpn_id';
741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
742: 'moqd.cost_group_id';
743:
744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
746: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
747: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
748:

Line 745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

741: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
742: 'moqd.cost_group_id';
743:
744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
746: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
747: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
748:
749: add_qf_where_onhand('ONHAND');

Line 746: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

742: 'moqd.cost_group_id';
743:
744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
746: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
747: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
748:
749: add_qf_where_onhand('ONHAND');
750:

Line 747: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

743:
744: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
745: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
746: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
747: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
748:
749: add_qf_where_onhand('ONHAND');
750:
751: WHEN 'LOT' THEN

Line 754: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

750:
751: WHEN 'LOT' THEN
752:
753: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
754: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
755: 'moqd.revision';
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';
758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

752:
753: INV_MWB_LOCATION_TREE.make_common_query_onhand('MOQD');
754: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
755: 'moqd.revision';
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';
758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
759: 'moqd.locator_id';
760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

754: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
755: 'moqd.revision';
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';
758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
759: 'moqd.locator_id';
760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
761: 'moqd.lpn_id';
762: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';
758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
759: 'moqd.locator_id';
760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
761: 'moqd.lpn_id';
762: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
763: 'moqd.cost_group_id';
764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 762: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

758: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
759: 'moqd.locator_id';
760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
761: 'moqd.lpn_id';
762: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
763: 'moqd.cost_group_id';
764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
765: 'moqd.lot_number';
766:

Line 764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

760: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
761: 'moqd.lpn_id';
762: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
763: 'moqd.cost_group_id';
764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
765: 'moqd.lot_number';
766:
767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

Line 767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

763: 'moqd.cost_group_id';
764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
765: 'moqd.lot_number';
766:
767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

Line 768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

764: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
765: 'moqd.lot_number';
766:
767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

Line 769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

765: 'moqd.lot_number';
766:
767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
773:

Line 770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

766:
767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
773:
774: -- Onhand Material Status Support

Line 771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

767: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
773:
774: -- Onhand Material Status Support
775: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.

Line 772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

768: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
770: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
773:
774: -- Onhand Material Status Support
775: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
776: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 787: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

783: end if;
784: end if;
785:
786: if (l_default_status_id is not null and l_serial_controlled = 0) then
787: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
788: 'moqd.status_id';
789: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
790: end if;
791: -- End Onhand Material Status Support

Line 789: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');

785:
786: if (l_default_status_id is not null and l_serial_controlled = 0) then
787: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
788: 'moqd.status_id';
789: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
790: end if;
791: -- End Onhand Material Status Support
792:
793: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

Line 794: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

790: end if;
791: -- End Onhand Material Status Support
792:
793: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
794: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
795: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
796: END IF;
797:
798: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

Line 795: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

791: -- End Onhand Material Status Support
792:
793: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
794: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
795: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
796: END IF;
797:
798: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
799: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');

Line 799: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');

795: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
796: END IF;
797:
798: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
799: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
800: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
801: ELSE
802: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
803: END IF;

Line 800: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

796: END IF;
797:
798: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
799: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
800: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
801: ELSE
802: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
803: END IF;
804:

Line 802: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');

798: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
799: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_tree_plpn_id', 'ONHAND');
800: inv_mwb_query_manager.add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
801: ELSE
802: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
803: END IF;
804:
805: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
806: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

Line 806: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');

802: inv_mwb_query_manager.add_where_clause('moqd.lpn_id IS NULL', 'ONHAND');
803: END IF;
804:
805: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
806: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
807: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
808: ELSE
809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
810: END IF;

Line 807: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);

803: END IF;
804:
805: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
806: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
807: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
808: ELSE
809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
810: END IF;
811:

Line 809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');

805: IF inv_mwb_globals.g_tree_loc_id IS NOT NULL THEN
806: inv_mwb_query_manager.add_where_clause('moqd.locator_id = :onh_tree_loc_id', 'ONHAND');
807: inv_mwb_query_manager.add_bind_variable('onh_tree_loc_id', inv_mwb_globals.g_tree_loc_id);
808: ELSE
809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
810: END IF;
811:
812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

Line 812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

808: ELSE
809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
810: END IF;
811:
812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:

Line 813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');

809: inv_mwb_query_manager.add_where_clause('moqd.locator_id IS NULL', 'ONHAND');
810: END IF;
811:
812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

810: END IF;
811:
812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

Line 815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');

811:
812: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

813: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = :onh_tree_subinventory_code', 'ONHAND');
814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
820: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_num', inv_mwb_globals.g_tree_node_value);
821:

Line 818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);

814: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
820: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_num', inv_mwb_globals.g_tree_node_value);
821:
822: add_qf_where_onhand('ONHAND');

Line 819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

815: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_num' ,'ONHAND');
816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
820: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_num', inv_mwb_globals.g_tree_node_value);
821:
822: add_qf_where_onhand('ONHAND');
823:

Line 820: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_num', inv_mwb_globals.g_tree_node_value);

816:
817: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
818: inv_mwb_query_manager.add_bind_variable('onh_tree_subinventory_code', inv_mwb_globals.g_tree_subinventory_code);
819: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
820: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_num', inv_mwb_globals.g_tree_node_value);
821:
822: add_qf_where_onhand('ONHAND');
823:
824: WHEN 'SERIAL' THEN

Line 864: inv_mwb_query_manager.add_where_clause(

860: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
861: AND organization_id = inv_mwb_globals.g_tree_organization_id;
862:
863: IF inv_mwb_globals.g_chk_onhand = 1 THEN
864: inv_mwb_query_manager.add_where_clause(
865: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
866: 'ONHAND'
867: );
868: inv_mwb_query_manager.add_where_clause(

Line 868: inv_mwb_query_manager.add_where_clause(

864: inv_mwb_query_manager.add_where_clause(
865: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
866: 'ONHAND'
867: );
868: inv_mwb_query_manager.add_where_clause(
869: 'moqd.organization_id = :onh_tree_organization_id' ,
870: 'ONHAND'
871: );
872: IF l_rev_control = 2 THEN

Line 873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

869: 'moqd.organization_id = :onh_tree_organization_id' ,
870: 'ONHAND'
871: );
872: IF l_rev_control = 2 THEN
873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
874: 'moqd.revision';
875: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
876: END IF;
877: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN

Line 875: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

871: );
872: IF l_rev_control = 2 THEN
873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
874: 'moqd.revision';
875: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
876: END IF;
877: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
878: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
879: 'moqd.lot_number';

Line 878: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

874: 'moqd.revision';
875: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
876: END IF;
877: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
878: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
879: 'moqd.lot_number';
880: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
881: END IF;
882:

Line 880: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

876: END IF;
877: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
878: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
879: 'moqd.lot_number';
880: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
881: END IF;
882:
883: inv_mwb_query_manager.add_bind_variable(
884: 'onh_tree_organization_id',

Line 883: inv_mwb_query_manager.add_bind_variable(

879: 'moqd.lot_number';
880: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
881: END IF;
882:
883: inv_mwb_query_manager.add_bind_variable(
884: 'onh_tree_organization_id',
885: inv_mwb_globals.g_tree_organization_id
886: );
887: inv_mwb_query_manager.add_bind_variable(

Line 887: inv_mwb_query_manager.add_bind_variable(

883: inv_mwb_query_manager.add_bind_variable(
884: 'onh_tree_organization_id',
885: inv_mwb_globals.g_tree_organization_id
886: );
887: inv_mwb_query_manager.add_bind_variable(
888: 'onh_tree_inventory_item_id',
889: inv_mwb_globals.g_tree_item_id
890: );
891: END IF; -- onhand check

Line 898: inv_mwb_query_manager.add_where_clause(

894:
895: WHEN 'ITEM' THEN
896:
897: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
898: inv_mwb_query_manager.add_where_clause(
899: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
900: 'ONHAND'
901: );
902: inv_mwb_query_manager.add_bind_variable(

Line 902: inv_mwb_query_manager.add_bind_variable(

898: inv_mwb_query_manager.add_where_clause(
899: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
900: 'ONHAND'
901: );
902: inv_mwb_query_manager.add_bind_variable(
903: 'onh_tree_inventory_item_id',
904: inv_mwb_globals.g_tree_item_id
905: );
906: add_qf_where_onhand('ONHAND');

Line 920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

916: AND organization_id = inv_mwb_globals.g_tree_organization_id;
917:
918: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
919:
920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

Line 922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

918: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
919:
920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN

Line 923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

919:
920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
928: 'moqd.lot_number';

Line 925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
928: 'moqd.lot_number';
929: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

Line 927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

923: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
924: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
928: 'moqd.lot_number';
929: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
930: END IF;
931:

Line 929: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

925: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
926: IF l_lot_control = 2 THEN
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
928: 'moqd.lot_number';
929: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
930: END IF;
931:
932: inv_mwb_query_manager.add_bind_variable(
933: 'onh_tree_organization_id',

Line 932: inv_mwb_query_manager.add_bind_variable(

928: 'moqd.lot_number';
929: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
930: END IF;
931:
932: inv_mwb_query_manager.add_bind_variable(
933: 'onh_tree_organization_id',
934: inv_mwb_globals.g_tree_organization_id
935: );
936: inv_mwb_query_manager.add_bind_variable(

Line 936: inv_mwb_query_manager.add_bind_variable(

932: inv_mwb_query_manager.add_bind_variable(
933: 'onh_tree_organization_id',
934: inv_mwb_globals.g_tree_organization_id
935: );
936: inv_mwb_query_manager.add_bind_variable(
937: 'onh_tree_inventory_item_id',
938: inv_mwb_globals.g_tree_item_id
939: );
940: inv_mwb_query_manager.add_bind_variable(

Line 940: inv_mwb_query_manager.add_bind_variable(

936: inv_mwb_query_manager.add_bind_variable(
937: 'onh_tree_inventory_item_id',
938: inv_mwb_globals.g_tree_item_id
939: );
940: inv_mwb_query_manager.add_bind_variable(
941: 'onh_tree_revision',
942: inv_mwb_globals.g_tree_rev
943: );
944: add_qf_where_onhand('ONHAND');

Line 960: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

956:
957: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
958:
959: IF l_rev_control = 2 THEN
960: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
961: 'moqd.revision';
962: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
964: END IF;

Line 962: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

958:
959: IF l_rev_control = 2 THEN
960: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
961: 'moqd.revision';
962: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
964: END IF;
965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
966: 'moqd.lot_number';

Line 963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');

959: IF l_rev_control = 2 THEN
960: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
961: 'moqd.revision';
962: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
964: END IF;
965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
966: 'moqd.lot_number';
967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');

Line 965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

961: 'moqd.revision';
962: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
964: END IF;
965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
966: 'moqd.lot_number';
967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
968:
969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

Line 967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');

963: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
964: END IF;
965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
966: 'moqd.lot_number';
967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
968:
969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');

Line 969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

965: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
966: 'moqd.lot_number';
967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
968:
969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

966: 'moqd.lot_number';
967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
968:
969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');

967: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
968:
969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

969: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
976: IF l_rev_control = 2 THEN
977: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

Line 974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

970: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
976: IF l_rev_control = 2 THEN
977: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
978: END IF;

Line 975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);

971: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
972:
973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
976: IF l_rev_control = 2 THEN
977: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
978: END IF;
979:

Line 977: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

973: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
974: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
975: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
976: IF l_rev_control = 2 THEN
977: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
978: END IF;
979:
980: add_qf_where_onhand('ONHAND');
981: WHEN 'SERIAL' THEN

Line 1013: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

1009: WHEN 'COST_GROUP' THEN
1010:
1011: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1012:
1013: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1014: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1015:
1016: add_qf_where_onhand('ONHAND');
1017:

Line 1014: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

1010:
1011: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1012:
1013: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1014: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1015:
1016: add_qf_where_onhand('ONHAND');
1017:
1018: WHEN 'ORG' THEN

Line 1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

1018: WHEN 'ORG' THEN
1019:
1020: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1021:
1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1025: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1026:

Line 1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

1019:
1020: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1021:
1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1025: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1026:
1027: add_qf_where_onhand('ONHAND');

Line 1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

1020: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1021:
1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1025: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1026:
1027: add_qf_where_onhand('ONHAND');
1028:

Line 1025: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

1021:
1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1025: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1026:
1027: add_qf_where_onhand('ONHAND');
1028:
1029: WHEN 'ITEM' THEN

Line 1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

1029: WHEN 'ITEM' THEN
1030:
1031: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1032:
1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

Line 1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

1030:
1031: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1032:
1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

1031: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1032:
1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1039:

Line 1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

1032:
1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1039:
1040: add_qf_where_onhand('ONHAND');

Line 1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1039:
1040: add_qf_where_onhand('ONHAND');
1041:

Line 1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
1036: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1037: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
1038: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1039:
1040: add_qf_where_onhand('ONHAND');
1041:
1042: WHEN 'SERIAL' THEN

Line 1074: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

1070: WHEN 'ORG' THEN
1071:
1072: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1073:
1074: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1075: 'moqd.lot_number';
1076: inv_mwb_query_manager.add_where_clause(
1077: 'moqd.organization_id = :onh_tree_organization_id' ,
1078: 'ONHAND'

Line 1076: inv_mwb_query_manager.add_where_clause(

1072: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1073:
1074: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1075: 'moqd.lot_number';
1076: inv_mwb_query_manager.add_where_clause(
1077: 'moqd.organization_id = :onh_tree_organization_id' ,
1078: 'ONHAND'
1079: );
1080: inv_mwb_query_manager.add_group_clause(

Line 1080: inv_mwb_query_manager.add_group_clause(

1076: inv_mwb_query_manager.add_where_clause(
1077: 'moqd.organization_id = :onh_tree_organization_id' ,
1078: 'ONHAND'
1079: );
1080: inv_mwb_query_manager.add_group_clause(
1081: 'moqd.lot_number' ,
1082: 'ONHAND'
1083: );
1084: inv_mwb_query_manager.add_bind_variable(

Line 1084: inv_mwb_query_manager.add_bind_variable(

1080: inv_mwb_query_manager.add_group_clause(
1081: 'moqd.lot_number' ,
1082: 'ONHAND'
1083: );
1084: inv_mwb_query_manager.add_bind_variable(
1085: 'onh_tree_organization_id',
1086: inv_mwb_globals.g_tree_organization_id
1087: );
1088:

Line 1103: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

1099: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1100:
1101: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1102:
1103: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1104: 'moqd.lot_number';
1105: IF l_rev_control = 2 THEN
1106: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
1107: 'moqd.revision';

Line 1106: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

1102:
1103: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1104: 'moqd.lot_number';
1105: IF l_rev_control = 2 THEN
1106: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
1107: 'moqd.revision';
1108: inv_mwb_query_manager.add_group_clause(
1109: 'moqd.revision' ,
1110: 'ONHAND'

Line 1108: inv_mwb_query_manager.add_group_clause(

1104: 'moqd.lot_number';
1105: IF l_rev_control = 2 THEN
1106: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
1107: 'moqd.revision';
1108: inv_mwb_query_manager.add_group_clause(
1109: 'moqd.revision' ,
1110: 'ONHAND'
1111: );
1112: END IF;

Line 1113: inv_mwb_query_manager.add_where_clause(

1109: 'moqd.revision' ,
1110: 'ONHAND'
1111: );
1112: END IF;
1113: inv_mwb_query_manager.add_where_clause(
1114: 'moqd.organization_id = :onh_tree_organization_id' ,
1115: 'ONHAND'
1116: );
1117: inv_mwb_query_manager.add_where_clause(

Line 1117: inv_mwb_query_manager.add_where_clause(

1113: inv_mwb_query_manager.add_where_clause(
1114: 'moqd.organization_id = :onh_tree_organization_id' ,
1115: 'ONHAND'
1116: );
1117: inv_mwb_query_manager.add_where_clause(
1118: 'moqd.lot_number = :onh_tree_lot_number' ,
1119: 'ONHAND'
1120: );
1121: inv_mwb_query_manager.add_where_clause(

Line 1121: inv_mwb_query_manager.add_where_clause(

1117: inv_mwb_query_manager.add_where_clause(
1118: 'moqd.lot_number = :onh_tree_lot_number' ,
1119: 'ONHAND'
1120: );
1121: inv_mwb_query_manager.add_where_clause(
1122: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
1123: 'ONHAND'
1124: );
1125: inv_mwb_query_manager.add_group_clause(

Line 1125: inv_mwb_query_manager.add_group_clause(

1121: inv_mwb_query_manager.add_where_clause(
1122: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
1123: 'ONHAND'
1124: );
1125: inv_mwb_query_manager.add_group_clause(
1126: 'moqd.lot_number' ,
1127: 'ONHAND'
1128: );
1129: inv_mwb_query_manager.add_bind_variable(

Line 1129: inv_mwb_query_manager.add_bind_variable(

1125: inv_mwb_query_manager.add_group_clause(
1126: 'moqd.lot_number' ,
1127: 'ONHAND'
1128: );
1129: inv_mwb_query_manager.add_bind_variable(
1130: 'onh_tree_organization_id',
1131: inv_mwb_globals.g_tree_organization_id
1132: );
1133: inv_mwb_query_manager.add_bind_variable(

Line 1133: inv_mwb_query_manager.add_bind_variable(

1129: inv_mwb_query_manager.add_bind_variable(
1130: 'onh_tree_organization_id',
1131: inv_mwb_globals.g_tree_organization_id
1132: );
1133: inv_mwb_query_manager.add_bind_variable(
1134: 'onh_tree_lot_number',
1135: inv_mwb_globals.g_tree_lot_number
1136: );
1137: inv_mwb_query_manager.add_bind_variable(

Line 1137: inv_mwb_query_manager.add_bind_variable(

1133: inv_mwb_query_manager.add_bind_variable(
1134: 'onh_tree_lot_number',
1135: inv_mwb_globals.g_tree_lot_number
1136: );
1137: inv_mwb_query_manager.add_bind_variable(
1138: 'onh_tree_inventory_item_id',
1139: inv_mwb_globals.g_tree_item_id
1140: );
1141:

Line 1152: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

1148: WHEN 'LOT' THEN
1149:
1150: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1151:
1152: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1153: 'moqd.lot_number';
1154: inv_mwb_query_manager.add_where_clause(
1155: 'moqd.organization_id = :onh_tree_organization_id' ,
1156: 'ONHAND'

Line 1154: inv_mwb_query_manager.add_where_clause(

1150: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1151:
1152: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1153: 'moqd.lot_number';
1154: inv_mwb_query_manager.add_where_clause(
1155: 'moqd.organization_id = :onh_tree_organization_id' ,
1156: 'ONHAND'
1157: );
1158: inv_mwb_query_manager.add_where_clause(

Line 1158: inv_mwb_query_manager.add_where_clause(

1154: inv_mwb_query_manager.add_where_clause(
1155: 'moqd.organization_id = :onh_tree_organization_id' ,
1156: 'ONHAND'
1157: );
1158: inv_mwb_query_manager.add_where_clause(
1159: 'moqd.lot_number = :onh_tree_lot_number' ,
1160: 'ONHAND'
1161: );
1162: inv_mwb_query_manager.add_group_clause(

Line 1162: inv_mwb_query_manager.add_group_clause(

1158: inv_mwb_query_manager.add_where_clause(
1159: 'moqd.lot_number = :onh_tree_lot_number' ,
1160: 'ONHAND'
1161: );
1162: inv_mwb_query_manager.add_group_clause(
1163: 'moqd.lot_number' ,
1164: 'ONHAND'
1165: );
1166: inv_mwb_query_manager.add_bind_variable(

Line 1166: inv_mwb_query_manager.add_bind_variable(

1162: inv_mwb_query_manager.add_group_clause(
1163: 'moqd.lot_number' ,
1164: 'ONHAND'
1165: );
1166: inv_mwb_query_manager.add_bind_variable(
1167: 'onh_tree_organization_id',
1168: inv_mwb_globals.g_tree_organization_id
1169: );
1170: inv_mwb_query_manager.add_bind_variable(

Line 1170: inv_mwb_query_manager.add_bind_variable(

1166: inv_mwb_query_manager.add_bind_variable(
1167: 'onh_tree_organization_id',
1168: inv_mwb_globals.g_tree_organization_id
1169: );
1170: inv_mwb_query_manager.add_bind_variable(
1171: 'onh_tree_lot_number',
1172: inv_mwb_globals.g_tree_lot_number
1173: );
1174:

Line 2266: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');

2262: END IF;
2263:
2264: IF inv_mwb_globals.g_inventory_item_id IS NULL
2265: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
2266: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');
2267: add_where_clause('moqd.inventory_item_id = msik.inventory_item_id', 'ONHAND');
2268: add_where_clause('moqd.organization_id = msik.organization_id', 'ONHAND');
2269: add_where_clause('msik.description like :onh_item_description', 'ONHAND');
2270: add_bind_variable('onh_item_description', inv_mwb_globals.g_item_description);

Line 2295: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');

2291: END IF;
2292:
2293: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2294: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2295: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2296: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2297: add_where_clause('moqd.lpn_id = wlpn.lpn_id', 'ONHAND');
2298: END IF;
2299:

Line 2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2440: if inv_mwb_globals.g_status_id is not null then
2441: if l_default_status_id is not null then
2442: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2443:
2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2448:

Line 2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');

2441: if l_default_status_id is not null then
2442: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2443:
2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2448:
2449: add_where_clause('moqd.status_id = :onh_status_id', 'ONHAND');

Line 2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');

2442: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2443:
2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2448:
2449: add_where_clause('moqd.status_id = :onh_status_id', 'ONHAND');
2450: add_bind_variable('onh_status_id', inv_mwb_globals.g_status_id);

Line 2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');

2443:
2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2448:
2449: add_where_clause('moqd.status_id = :onh_status_id', 'ONHAND');
2450: add_bind_variable('onh_status_id', inv_mwb_globals.g_status_id);
2451: end if;

Line 2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2452: else
2453: -- Bug 6060233
2454: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');

Line 2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');

2453: -- Bug 6060233
2454: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');

Line 2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

2454: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');

Line 2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');

Line 2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');

2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');

Line 2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');

2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');

Line 2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');

2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');

Line 2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');

2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');

Line 2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');

2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');

Line 2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');

2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');

Line 2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');

2462: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mil.organization_id(+)', 'ONHAND');
2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');

Line 2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');

2463: inv_mwb_query_manager.add_where_clause('moqd.locator_id = mil.inventory_location_id(+)', 'ONHAND');
2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2471:

Line 2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');

2464: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id(+)', 'ONHAND');
2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2471:
2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||

Line 2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');

2465: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2471:
2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||
2473: ' OR mil.status_id = :mil_status_id' ||

Line 2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');

2466: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number(+)', 'ONHAND');
2467: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msi.organization_id', 'ONHAND');
2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2471:
2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||
2473: ' OR mil.status_id = :mil_status_id' ||
2474: ' OR mln.status_id = :mln_status_id)', 'ONHAND');

Line 2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||

2468: inv_mwb_query_manager.add_where_clause('moqd.subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2469: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2470: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2471:
2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||
2473: ' OR mil.status_id = :mil_status_id' ||
2474: ' OR mln.status_id = :mln_status_id)', 'ONHAND');
2475:
2476: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);

Line 2476: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);

2472: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||
2473: ' OR mil.status_id = :mil_status_id' ||
2474: ' OR mln.status_id = :mln_status_id)', 'ONHAND');
2475:
2476: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2477: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2478: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2479: END IF;
2480: -- End Bug 6060233

Line 2477: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);

2473: ' OR mil.status_id = :mil_status_id' ||
2474: ' OR mln.status_id = :mln_status_id)', 'ONHAND');
2475:
2476: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2477: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2478: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2479: END IF;
2480: -- End Bug 6060233
2481: end if;

Line 2478: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);

2474: ' OR mln.status_id = :mln_status_id)', 'ONHAND');
2475:
2476: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2477: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2478: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2479: END IF;
2480: -- End Bug 6060233
2481: end if;
2482: end if;

Line 2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');

2486: WHEN 'ONHAND_MSN' THEN
2487:
2488: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');

Line 2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

2487:
2488: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');

Line 2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

2488: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');

Line 2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');

2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');

Line 2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');

2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');

Line 2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');

2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');

Line 2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');

2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');

Line 2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');

2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');

Line 2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');

2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');
2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2502:

Line 2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');

2495: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mln.organization_id(+)', 'ONHAND');
2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2502:
2503: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN

Line 2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');

2496: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = mln.inventory_item_id(+)', 'ONHAND');
2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2502:
2503: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2504:

Line 2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');

2497: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number(+)', 'ONHAND');
2498: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = msi.organization_id', 'ONHAND');
2499: inv_mwb_query_manager.add_where_clause('msn.current_subinventory_code = msi.secondary_inventory_name', 'ONHAND');
2500: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2501: inv_mwb_query_manager.add_where_clause('(msi.subinventory_type = 1 OR msi.subinventory_type IS NULL)', 'ONHAND');
2502:
2503: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2504:
2505: -- Bug 6060233

Line 2506: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||

2502:
2503: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2504:
2505: -- Bug 6060233
2506: inv_mwb_query_manager.add_where_clause('(msi.status_id = :msi_status_id' ||
2507: ' OR mil.status_id = :mil_status_id' ||
2508: ' OR mln.status_id = :mln_status_id' ||
2509: ' OR msn.status_id = :msn_status_id)', 'ONHAND');
2510:

Line 2512: inv_mwb_query_manager.add_where_clause('msi.status_id = :msi_status_id', 'ONHAND');

2508: ' OR mln.status_id = :mln_status_id' ||
2509: ' OR msn.status_id = :msn_status_id)', 'ONHAND');
2510:
2511: /*
2512: inv_mwb_query_manager.add_where_clause('msi.status_id = :msi_status_id', 'ONHAND');
2513: inv_mwb_query_manager.add_where_clause('mil.status_id = :mil_status_id', 'ONHAND');
2514: inv_mwb_query_manager.add_where_clause('mln.status_id = :mln_status_id', 'ONHAND');
2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');
2516: */

Line 2513: inv_mwb_query_manager.add_where_clause('mil.status_id = :mil_status_id', 'ONHAND');

2509: ' OR msn.status_id = :msn_status_id)', 'ONHAND');
2510:
2511: /*
2512: inv_mwb_query_manager.add_where_clause('msi.status_id = :msi_status_id', 'ONHAND');
2513: inv_mwb_query_manager.add_where_clause('mil.status_id = :mil_status_id', 'ONHAND');
2514: inv_mwb_query_manager.add_where_clause('mln.status_id = :mln_status_id', 'ONHAND');
2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');
2516: */
2517: -- End Bug 6060233

Line 2514: inv_mwb_query_manager.add_where_clause('mln.status_id = :mln_status_id', 'ONHAND');

2510:
2511: /*
2512: inv_mwb_query_manager.add_where_clause('msi.status_id = :msi_status_id', 'ONHAND');
2513: inv_mwb_query_manager.add_where_clause('mil.status_id = :mil_status_id', 'ONHAND');
2514: inv_mwb_query_manager.add_where_clause('mln.status_id = :mln_status_id', 'ONHAND');
2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');
2516: */
2517: -- End Bug 6060233
2518:

Line 2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');

2511: /*
2512: inv_mwb_query_manager.add_where_clause('msi.status_id = :msi_status_id', 'ONHAND');
2513: inv_mwb_query_manager.add_where_clause('mil.status_id = :mil_status_id', 'ONHAND');
2514: inv_mwb_query_manager.add_where_clause('mln.status_id = :mln_status_id', 'ONHAND');
2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');
2516: */
2517: -- End Bug 6060233
2518:
2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);

Line 2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);

2515: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id', 'ONHAND');
2516: */
2517: -- End Bug 6060233
2518:
2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2520: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2523: END IF;

Line 2520: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);

2516: */
2517: -- End Bug 6060233
2518:
2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2520: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2523: END IF;
2524: else -- Onhand Material Status Support

Line 2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);

2517: -- End Bug 6060233
2518:
2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2520: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2523: END IF;
2524: else -- Onhand Material Status Support
2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');

Line 2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);

2518:
2519: inv_mwb_query_manager.add_bind_variable('msi_status_id', inv_mwb_globals.g_status_id);
2520: inv_mwb_query_manager.add_bind_variable('mil_status_id', inv_mwb_globals.g_status_id);
2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2523: END IF;
2524: else -- Onhand Material Status Support
2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2526: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN

Line 2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');

2521: inv_mwb_query_manager.add_bind_variable('mln_status_id', inv_mwb_globals.g_status_id);
2522: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2523: END IF;
2524: else -- Onhand Material Status Support
2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2526: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2527: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id','ONHAND');
2528: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2529: END IF;

Line 2527: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id','ONHAND');

2523: END IF;
2524: else -- Onhand Material Status Support
2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2526: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2527: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id','ONHAND');
2528: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2529: END IF;
2530: end if;
2531: END IF;

Line 2528: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);

2524: else -- Onhand Material Status Support
2525: inv_mwb_query_manager.add_where_clause('NVL (msn.organization_type, 2) = 2', 'ONHAND');
2526: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2527: inv_mwb_query_manager.add_where_clause('msn.status_id = :msn_status_id','ONHAND');
2528: inv_mwb_query_manager.add_bind_variable('msn_status_id', inv_mwb_globals.g_status_id);
2529: END IF;
2530: end if;
2531: END IF;
2532:

Line 2575: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');

2571: END IF;
2572:
2573: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2574: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2575: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2576: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'ONHAND');
2577: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2578: END IF;
2579:

Line 2790: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);

2786: END CASE;
2787: END IF;
2788: END IF;
2789: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Adding tables to the query : ' || p_mat_loc);
2790: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);
2791: inv_mwb_query_manager.add_from_clause(' wms_lpn_contents wlc ', p_mat_loc);
2792: add_where_clause(' wlc.parent_lpn_id = wlpn.lpn_id ', p_mat_loc);
2793:
2794: IF inv_mwb_globals.g_serial_from IS NOT NULL

Line 2791: inv_mwb_query_manager.add_from_clause(' wms_lpn_contents wlc ', p_mat_loc);

2787: END IF;
2788: END IF;
2789: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Adding tables to the query : ' || p_mat_loc);
2790: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);
2791: inv_mwb_query_manager.add_from_clause(' wms_lpn_contents wlc ', p_mat_loc);
2792: add_where_clause(' wlc.parent_lpn_id = wlpn.lpn_id ', p_mat_loc);
2793:
2794: IF inv_mwb_globals.g_serial_from IS NOT NULL
2795: OR inv_mwb_globals.g_serial_to IS NOT NULL

Line 2798: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ',p_mat_loc);

2794: IF inv_mwb_globals.g_serial_from IS NOT NULL
2795: OR inv_mwb_globals.g_serial_to IS NOT NULL
2796: OR inv_mwb_globals.g_tree_serial_number IS NOT NULL
2797: OR l_serial_control IN (2, 5) THEN
2798: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ',p_mat_loc);
2799: add_where_clause('msn.lpn_id = wlpn.lpn_id', p_mat_loc);
2800: add_where_clause('msn.current_organization_id = wlc.organization_id', p_mat_loc);
2801: add_where_clause('msn.inventory_item_id = wlc.inventory_item_id', p_mat_loc);
2802:

Line 2827: inv_mwb_query_manager.add_from_clause(' mtl_item_locations mil ',p_mat_loc);

2823: END IF;
2824:
2825: IF inv_mwb_globals.g_project_id IS NOT NULL
2826: OR inv_mwb_globals.g_task_id IS NOT NULL THEN
2827: inv_mwb_query_manager.add_from_clause(' mtl_item_locations mil ',p_mat_loc);
2828: add_where_clause('msn.lpn_id = wlpn.lpn_id', p_mat_loc);
2829: add_where_clause('mil.organization_id = wlc.organization_id', p_mat_loc);
2830: add_where_clause('wlpn.locator = mil.inventory_location_id', p_mat_loc);
2831: END IF;

Line 3001: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');

2997: IF p_flag = 'TREE_LPN' THEN
2998: null;
2999: ELSIF p_flag = 'RECEIVING' THEN
3000: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Addding table');
3001: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');
3002: IF (inv_mwb_globals.g_lot_from IS NOT NULL
3003: OR inv_mwb_globals.g_lot_to IS NOT NULL)
3004: OR l_lot_control = 2 THEN
3005: inv_mwb_query_manager.add_from_clause('rcv_lots_supply rls','RECEIVING');

Line 3005: inv_mwb_query_manager.add_from_clause('rcv_lots_supply rls','RECEIVING');

3001: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');
3002: IF (inv_mwb_globals.g_lot_from IS NOT NULL
3003: OR inv_mwb_globals.g_lot_to IS NOT NULL)
3004: OR l_lot_control = 2 THEN
3005: inv_mwb_query_manager.add_from_clause('rcv_lots_supply rls','RECEIVING');
3006: add_where_clause('rls.shipment_line_id(+) = rs.shipment_line_id', 'RECEIVING');
3007:
3008: IF inv_mwb_globals.g_tree_lot_number IS NULL THEN
3009:

Line 3053: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

3049: END IF;
3050:
3051: IF inv_mwb_globals.g_inventory_item_id IS NULL
3052: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3053: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3054: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3055: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3056: add_where_clause('msib.description LIKE :rcv_item_description', 'RECEIVING');
3057: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 3067: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3063: END IF;
3064:
3065: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3066: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3067: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3068: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3069: END IF;
3070:
3071: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3092: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ','RECEIVING');

3088: END IF;
3089:
3090: ELSIF p_flag = 'MSN_RECEIVING' THEN
3091:
3092: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ','RECEIVING');
3093: add_where_clause('msn.current_status = 7', 'RECEIVING');
3094:
3095: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3096: add_where_clause('msn.current_organization_id = :rcv_to_organization_id', 'RECEIVING');

Line 3117: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');

3113: END IF;
3114:
3115: IF inv_mwb_globals.g_inventory_item_id IS NULL
3116: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3117: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');
3118: add_where_clause('msik.inventory_item_id = msn.inventory_item_id', 'RECEIVING');
3119: add_where_clause('msik.organization_id = msn.current_organization_id', 'RECEIVING');
3120: add_where_clause('msik.description LIKE '':rcv_item_description''', 'RECEIVING');
3121: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 3131: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3127: END IF;
3128:
3129: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3130: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3131: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3132: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'RECEIVING');
3133: END IF;
3134:
3135: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3193: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');

3189: add_bind_variable('rcv_lot_to', inv_mwb_globals.g_lot_to);
3190: END IF;
3191: ELSIF p_flag = 'MSN' THEN
3192:
3193: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');
3194: inv_mwb_query_manager.add_from_clause('rcv_serials_supply rss','RECEIVING');
3195: add_where_clause('rs.shipment_line_id = rss.shipment_line_id (+) ', 'RECEIVING');
3196:
3197: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN

Line 3194: inv_mwb_query_manager.add_from_clause('rcv_serials_supply rss','RECEIVING');

3190: END IF;
3191: ELSIF p_flag = 'MSN' THEN
3192:
3193: inv_mwb_query_manager.add_from_clause(' rcv_supply rs ','RECEIVING');
3194: inv_mwb_query_manager.add_from_clause('rcv_serials_supply rss','RECEIVING');
3195: add_where_clause('rs.shipment_line_id = rss.shipment_line_id (+) ', 'RECEIVING');
3196:
3197: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3198: add_where_clause('rs.to_organization_id = :rcv_to_organization_id', 'RECEIVING');

Line 3219: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

3215: END IF;
3216:
3217: IF inv_mwb_globals.g_inventory_item_id IS NULL
3218: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3219: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3220: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3221: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3222: add_where_clause('msib.description LIKE :rcv_item_description', 'RECEIVING');
3223: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 3233: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3229: END IF;
3230:
3231: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3232: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3233: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3234: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3235: END IF;
3236:
3237: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3322: inv_mwb_query_manager.add_from_clause(' mtl_supply ms ','INBOUND');

3318: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3319:
3320: END IF;
3321:
3322: inv_mwb_query_manager.add_from_clause(' mtl_supply ms ','INBOUND');
3323: inv_mwb_query_manager.add_where_clause('ms.supply_type_code <> ''RECEIVING''','INBOUND');
3324: inv_mwb_query_manager.add_where_clause('ms.destination_type_code = ''INVENTORY''','INBOUND');
3325: IF inv_mwb_globals.g_po_header_id IS NOT NULL
3326: OR inv_mwb_globals.g_vendor_id IS NOT NULL

Line 3323: inv_mwb_query_manager.add_where_clause('ms.supply_type_code <> ''RECEIVING''','INBOUND');

3319:
3320: END IF;
3321:
3322: inv_mwb_query_manager.add_from_clause(' mtl_supply ms ','INBOUND');
3323: inv_mwb_query_manager.add_where_clause('ms.supply_type_code <> ''RECEIVING''','INBOUND');
3324: inv_mwb_query_manager.add_where_clause('ms.destination_type_code = ''INVENTORY''','INBOUND');
3325: IF inv_mwb_globals.g_po_header_id IS NOT NULL
3326: OR inv_mwb_globals.g_vendor_id IS NOT NULL
3327: OR inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL

Line 3324: inv_mwb_query_manager.add_where_clause('ms.destination_type_code = ''INVENTORY''','INBOUND');

3320: END IF;
3321:
3322: inv_mwb_query_manager.add_from_clause(' mtl_supply ms ','INBOUND');
3323: inv_mwb_query_manager.add_where_clause('ms.supply_type_code <> ''RECEIVING''','INBOUND');
3324: inv_mwb_query_manager.add_where_clause('ms.destination_type_code = ''INVENTORY''','INBOUND');
3325: IF inv_mwb_globals.g_po_header_id IS NOT NULL
3326: OR inv_mwb_globals.g_vendor_id IS NOT NULL
3327: OR inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL
3328: OR inv_mwb_globals.g_vendor_item IS NOT NULL THEN

Line 3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');

3328: OR inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3329:
3330: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Supplier tab');
3331:
3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');
3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN

Line 3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');

3329:
3330: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Supplier tab');
3331:
3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');
3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN
3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');

Line 3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');

3330: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Supplier tab');
3331:
3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');
3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN
3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');
3338: ELSIF inv_mwb_globals.g_include_po_without_asn = 0 THEN

Line 3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');

3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN
3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');
3338: ELSIF inv_mwb_globals.g_include_po_without_asn = 0 THEN
3339: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''SHIPMENT''','INBOUND');
3340: -- inv_mwb_query_manager.add_where_clause(' ms.shipment_header_id IS NULL','INBOUND');
3341: END IF;

Line 3339: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''SHIPMENT''','INBOUND');

3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN
3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');
3338: ELSIF inv_mwb_globals.g_include_po_without_asn = 0 THEN
3339: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''SHIPMENT''','INBOUND');
3340: -- inv_mwb_query_manager.add_where_clause(' ms.shipment_header_id IS NULL','INBOUND');
3341: END IF;
3342: */
3343:

Line 3340: -- inv_mwb_query_manager.add_where_clause(' ms.shipment_header_id IS NULL','INBOUND');

3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN
3337: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''PO'',''SHIPMENT'')','INBOUND');
3338: ELSIF inv_mwb_globals.g_include_po_without_asn = 0 THEN
3339: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''SHIPMENT''','INBOUND');
3340: -- inv_mwb_query_manager.add_where_clause(' ms.shipment_header_id IS NULL','INBOUND');
3341: END IF;
3342: */
3343:
3344: IF inv_mwb_globals.g_vendor_id IS NOT NULL THEN

Line 3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');

3350: END IF;
3351: END IF;
3352:
3353: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');
3355: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');
3356: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');
3357: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
3358: END IF;

Line 3355: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');

3351: END IF;
3352:
3353: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');
3355: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');
3356: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');
3357: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
3358: END IF;
3359:

Line 3356: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');

3352:
3353: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');
3355: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');
3356: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');
3357: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
3358: END IF;
3359:
3360: IF inv_mwb_globals.g_po_header_id IS NOT NULL THEN

Line 3361: inv_mwb_query_manager.add_where_clause(' ms.po_header_id = :inb_po_header_id ','INBOUND');

3357: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
3358: END IF;
3359:
3360: IF inv_mwb_globals.g_po_header_id IS NOT NULL THEN
3361: inv_mwb_query_manager.add_where_clause(' ms.po_header_id = :inb_po_header_id ','INBOUND');
3362: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''PO'' ','INBOUND');
3363: add_bind_variable('inb_po_header_id', inv_mwb_globals.g_po_header_id);
3364: END IF;
3365:

Line 3362: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''PO'' ','INBOUND');

3358: END IF;
3359:
3360: IF inv_mwb_globals.g_po_header_id IS NOT NULL THEN
3361: inv_mwb_query_manager.add_where_clause(' ms.po_header_id = :inb_po_header_id ','INBOUND');
3362: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code = ''PO'' ','INBOUND');
3363: add_bind_variable('inb_po_header_id', inv_mwb_globals.g_po_header_id);
3364: END IF;
3365:
3366: IF inv_mwb_globals.g_po_release_id IS NOT NULL THEN

Line 3373: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

3369: END IF;
3370:
3371: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL
3372: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
3373: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3374: add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id', 'INBOUND');
3375: END IF;
3376:
3377: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL THEN

Line 3378: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id = :inb_shipment_header_id_asn ','INBOUND');

3374: add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id', 'INBOUND');
3375: END IF;
3376:
3377: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL THEN
3378: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id = :inb_shipment_header_id_asn ','INBOUND');
3379: add_bind_variable('inb_shipment_header_id_asn', inv_mwb_globals.g_shipment_header_id_asn);
3380: END IF;
3381:
3382: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL

Line 3384: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');

3380: END IF;
3381:
3382: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL
3383: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
3384: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3385: add_where_clause('rsl.shipment_line_id = ms.shipment_line_id', 'INBOUND');
3386: END IF;
3387:
3388: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

Line 3389: inv_mwb_query_manager.add_where_clause(' rsl.asn_lpn_id = :inb_asn_lpn_id ','INBOUND');

3385: add_where_clause('rsl.shipment_line_id = ms.shipment_line_id', 'INBOUND');
3386: END IF;
3387:
3388: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN
3389: inv_mwb_query_manager.add_where_clause(' rsl.asn_lpn_id = :inb_asn_lpn_id ','INBOUND');
3390: add_bind_variable('inb_asn_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
3391: END IF;
3392:
3393: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN

Line 3439: inv_mwb_query_manager.add_from_clause(' rcv_lots_supply rls ','INBOUND');

3435: IF (inv_mwb_globals.g_lot_from IS NOT NULL
3436: OR inv_mwb_globals.g_lot_to IS NOT NULL)
3437: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
3438: AND l_lot_control = 2) THEN
3439: inv_mwb_query_manager.add_from_clause(' rcv_lots_supply rls ','INBOUND');
3440: add_where_clause('rls.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3441: END IF;
3442:
3443: IF (inv_mwb_globals.g_lot_from IS NOT NULL AND

Line 3466: inv_mwb_query_manager.add_from_clause(' rcv_serials_supply rss ','INBOUND');

3462: IF (inv_mwb_globals.g_serial_from IS NOT NULL
3463: OR inv_mwb_globals.g_serial_to IS NOT NULL)
3464: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
3465: AND l_serial_control = 2) THEN
3466: inv_mwb_query_manager.add_from_clause(' rcv_serials_supply rss ','INBOUND');
3467: add_where_clause('rss.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3468: END IF;
3469:
3470: IF (inv_mwb_globals.g_serial_from IS NOT NULL AND

Line 3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

3492: OR inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL THEN
3493:
3494: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Interorg tab');
3495:
3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');

Line 3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');

3493:
3494: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Interorg tab');
3495:
3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');

Line 3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');

3495:
3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');
3502: inv_mwb_query_manager.add_where_clause(' rsh.asn_type IS NULL ', 'INBOUND');
3503:

Line 3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');

3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');
3502: inv_mwb_query_manager.add_where_clause(' rsh.asn_type IS NULL ', 'INBOUND');
3503:
3504:

Line 3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');

3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');
3502: inv_mwb_query_manager.add_where_clause(' rsh.asn_type IS NULL ', 'INBOUND');
3503:
3504:
3505: IF inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL THEN

Line 3502: inv_mwb_query_manager.add_where_clause(' rsh.asn_type IS NULL ', 'INBOUND');

3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');
3502: inv_mwb_query_manager.add_where_clause(' rsh.asn_type IS NULL ', 'INBOUND');
3503:
3504:
3505: IF inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL THEN
3506: add_where_clause(' rsh.shipment_header_id = :inb_shipment_header_id ', 'INBOUND');

Line 3510: inv_mwb_query_manager.add_where_clause(' ms.req_header_id = :inb_req_header_id ', 'INBOUND');

3506: add_where_clause(' rsh.shipment_header_id = :inb_shipment_header_id ', 'INBOUND');
3507: add_where_clause(' ms.supply_type_code = ''SHIPMENT'' ', 'INBOUND');
3508: add_bind_variable('inb_shipment_header_id', inv_mwb_globals.g_shipment_header_id_interorg);
3509: ELSIF inv_mwb_globals.g_req_header_id IS NOT NULL THEN
3510: inv_mwb_query_manager.add_where_clause(' ms.req_header_id = :inb_req_header_id ', 'INBOUND');
3511: add_bind_variable('inb_req_header_id', inv_mwb_globals.g_req_header_id);
3512: END IF;
3513:
3514: IF inv_mwb_globals.g_source_org_id IS NOT NULL THEN

Line 3515: inv_mwb_query_manager.add_where_clause(' ms.from_organization_id = :inb_from_organization_id ', 'INBOUND');

3511: add_bind_variable('inb_req_header_id', inv_mwb_globals.g_req_header_id);
3512: END IF;
3513:
3514: IF inv_mwb_globals.g_source_org_id IS NOT NULL THEN
3515: inv_mwb_query_manager.add_where_clause(' ms.from_organization_id = :inb_from_organization_id ', 'INBOUND');
3516: add_bind_variable('inb_from_organization_id', inv_mwb_globals.g_source_org_id);
3517: END IF;
3518:
3519: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN

Line 3558: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');

3554: END IF;
3555:
3556: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3557: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3558: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
3559: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
3560: END IF;
3561:
3562: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3587: inv_mwb_query_manager.add_from_clause(' rcv_lots_supply rls ','INBOUND');

3583: IF (inv_mwb_globals.g_lot_from IS NOT NULL
3584: OR inv_mwb_globals.g_lot_to IS NOT NULL)
3585: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
3586: AND l_lot_control = 2) THEN
3587: inv_mwb_query_manager.add_from_clause(' rcv_lots_supply rls ','INBOUND');
3588: add_where_clause('rls.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3589: END IF;
3590:
3591: IF (inv_mwb_globals.g_lot_from IS NOT NULL AND

Line 3615: inv_mwb_query_manager.add_from_clause(' rcv_serials_supply rss ','INBOUND');

3611: IF (inv_mwb_globals.g_serial_from IS NOT NULL
3612: OR inv_mwb_globals.g_serial_to IS NOT NULL)
3613: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
3614: AND l_serial_control =2) THEN
3615: inv_mwb_query_manager.add_from_clause(' rcv_serials_supply rss ','INBOUND');
3616: add_where_clause('rss.shipment_line_id = ms.shipment_line_id ', 'INBOUND');
3617: END IF;
3618:
3619: IF (inv_mwb_globals.g_serial_from IS NOT NULL AND

Line 3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');

3645: END IF;
3646:
3647: ELSE -- If interorg and supplier tab null
3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653:

Line 3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');

3646:
3647: ELSE -- If interorg and supplier tab null
3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653:
3654: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN

Line 3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');

3647: ELSE -- If interorg and supplier tab null
3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653:
3654: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3655: add_where_clause('ms.to_organization_id = :inb_to_organization_id', 'INBOUND');

Line 3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');

3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653:
3654: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3655: add_where_clause('ms.to_organization_id = :inb_to_organization_id', 'INBOUND');
3656: add_bind_variable('inb_to_organization_id', inv_mwb_globals.g_organization_id);

Line 3676: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');

3672: END IF;
3673:
3674: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3675: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3676: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
3677: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
3678: END IF;
3679:
3680: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3732: inv_mwb_query_manager.add_from_clause('rcv_serials_supply rss','INBOUND');

3728: OR inv_mwb_globals.g_serial_to IS NOT NULL
3729: OR (inv_mwb_globals.g_tree_item_id IS NOT NULL
3730: AND l_serial_control = 2)
3731: OR inv_mwb_globals.g_tree_serial_number IS NOT NULL THEN
3732: inv_mwb_query_manager.add_from_clause('rcv_serials_supply rss','INBOUND');
3733: add_where_clause('rss.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3734: END IF;
3735:
3736: IF (inv_mwb_globals.g_serial_from IS NOT NULL AND

Line 6215: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

6211: RETURN;
6212: END IF;
6213:
6214: add_from_clause('wms_license_plate_numbers wlpn', 'ONHAND_1');
6215: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6216: 'wlpn.subinventory_code';
6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6218: 'wlpn.locator_id';
6219: g_onhand_1_select(inv_mwb_query_manager.LPN).column_value :=

Line 6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

6213:
6214: add_from_clause('wms_license_plate_numbers wlpn', 'ONHAND_1');
6215: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6216: 'wlpn.subinventory_code';
6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6218: 'wlpn.locator_id';
6219: g_onhand_1_select(inv_mwb_query_manager.LPN).column_value :=
6220: 'wlpn.license_plate_number';
6221: g_onhand_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

Line 6219: g_onhand_1_select(inv_mwb_query_manager.LPN).column_value :=

6215: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6216: 'wlpn.subinventory_code';
6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6218: 'wlpn.locator_id';
6219: g_onhand_1_select(inv_mwb_query_manager.LPN).column_value :=
6220: 'wlpn.license_plate_number';
6221: g_onhand_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6222: 'wlpn.organization_id';
6223:

Line 6221: g_onhand_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6218: 'wlpn.locator_id';
6219: g_onhand_1_select(inv_mwb_query_manager.LPN).column_value :=
6220: 'wlpn.license_plate_number';
6221: g_onhand_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6222: 'wlpn.organization_id';
6223:
6224: add_group_clause('wlpn.organization_id', 'ONHAND_1');
6225: add_group_clause('wlpn.subinventory_code', 'ONHAND_1');

Line 6253: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');

6249: inv_mwb_globals.g_is_nested_lpn := 'NO';
6250: RETURN;
6251: END IF;
6252:
6253: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');
6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6255: 'wlpn.subinventory_code';
6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';

Line 6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

6250: RETURN;
6251: END IF;
6252:
6253: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');
6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6255: 'wlpn.subinventory_code';
6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';
6258: g_receiving_1_select(inv_mwb_query_manager.LPN).column_value :=

Line 6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

6252:
6253: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');
6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6255: 'wlpn.subinventory_code';
6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';
6258: g_receiving_1_select(inv_mwb_query_manager.LPN).column_value :=
6259: 'wlpn.license_plate_number';
6260: g_receiving_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

Line 6258: g_receiving_1_select(inv_mwb_query_manager.LPN).column_value :=

6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6255: 'wlpn.subinventory_code';
6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';
6258: g_receiving_1_select(inv_mwb_query_manager.LPN).column_value :=
6259: 'wlpn.license_plate_number';
6260: g_receiving_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6261: 'wlpn.organization_id';
6262:

Line 6260: g_receiving_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';
6258: g_receiving_1_select(inv_mwb_query_manager.LPN).column_value :=
6259: 'wlpn.license_plate_number';
6260: g_receiving_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6261: 'wlpn.organization_id';
6262:
6263: add_group_clause('wlpn.organization_id', 'RECEIVING_1');
6264: add_group_clause('wlpn.subinventory_code', 'RECEIVING_1');

Line 6294: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

6290: END IF;
6291:
6292: add_from_clause('wms_license_plate_numbers wlpn', 'INBOUND_1');
6293:
6294: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6295: 'wlpn.subinventory_code';
6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6297: 'wlpn.locator_id';
6298: g_inbound_1_select(inv_mwb_query_manager.LPN).column_value :=

Line 6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

6292: add_from_clause('wms_license_plate_numbers wlpn', 'INBOUND_1');
6293:
6294: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6295: 'wlpn.subinventory_code';
6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6297: 'wlpn.locator_id';
6298: g_inbound_1_select(inv_mwb_query_manager.LPN).column_value :=
6299: 'wlpn.license_plate_number';
6300: g_inbound_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

Line 6298: g_inbound_1_select(inv_mwb_query_manager.LPN).column_value :=

6294: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6295: 'wlpn.subinventory_code';
6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6297: 'wlpn.locator_id';
6298: g_inbound_1_select(inv_mwb_query_manager.LPN).column_value :=
6299: 'wlpn.license_plate_number';
6300: g_inbound_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6301: 'wlpn.organization_id';
6302:

Line 6300: g_inbound_1_select(inv_mwb_query_manager.ORG_ID).column_value :=

6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6297: 'wlpn.locator_id';
6298: g_inbound_1_select(inv_mwb_query_manager.LPN).column_value :=
6299: 'wlpn.license_plate_number';
6300: g_inbound_1_select(inv_mwb_query_manager.ORG_ID).column_value :=
6301: 'wlpn.organization_id';
6302:
6303: add_group_clause('wlpn.organization_id', 'INBOUND_1');
6304: add_group_clause('wlpn.subinventory_code', 'INBOUND_1');

Line 6313: END INV_MWB_QUERY_MANAGER;

6309: add_bind_variable('onh_tree_plpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
6310:
6311: END make_nested_lpn_inbound_query;
6312:
6313: END INV_MWB_QUERY_MANAGER;