APPS.INVPVHDR dependencies on MTL_PARAMETERS

Line 731: ** on org_id and segment(s), add a (dummy) join to mtl_parameters

727: ** ensure that they have the same item id
728: ** 08-APR-96 This code now completely rewritten using
729: ** dynamic sql.
730: ** 04SEP96 To remove full table scan on msi by using the msi index
731: ** on org_id and segment(s), add a (dummy) join to mtl_parameters
732: ** The + 0 has been put in so the mtl_parameters index is not used
733: */
734: select count(*)
735: into is_master_org

Line 732: ** The + 0 has been put in so the mtl_parameters index is not used

728: ** 08-APR-96 This code now completely rewritten using
729: ** dynamic sql.
730: ** 04SEP96 To remove full table scan on msi by using the msi index
731: ** on org_id and segment(s), add a (dummy) join to mtl_parameters
732: ** The + 0 has been put in so the mtl_parameters index is not used
733: */
734: select count(*)
735: into is_master_org
736: from mtl_parameters

Line 736: from mtl_parameters

732: ** The + 0 has been put in so the mtl_parameters index is not used
733: */
734: select count(*)
735: into is_master_org
736: from mtl_parameters
737: where organization_id = cr.organization_id
738: and master_organization_id = cr.organization_id ;
739:
740: If (is_master_org = 1) then

Line 743: from mtl_parameters

739:
740: If (is_master_org = 1) then
741: select count(*)
742: into no_of_masterorgs
743: from mtl_parameters
744: where organization_id = master_organization_id ;
745:
746: If (no_of_masterorgs > 1) then
747: BEGIN /* PLSQL Block1 */

Line 756: mtl_parameters mp

752: /* removed + 0 from where condition
753: and clause of organization_id to fix bug 7459820 with base bug 7003119 */
754: DSQL_statement1 := 'select distinct msi.inventory_item_id
755: from mtl_system_items msi,
756: mtl_parameters mp
757: where msi.organization_id <>
758: :organization_id_bind
759: and msi.inventory_item_id <> :l_item_id_bind
760: and msi.organization_id = mp.organization_id

Line 878: ** join to mtl_parameters The + 0 has been put in so

874: **a big resource hog, because of nvl to nvl
875: **comparison in statement_temp2
876: ** 04SEP96 To remove full table scan on msii by using the
877: ** msii index on org_id and segment(s), add a (dummy)
878: ** join to mtl_parameters The + 0 has been put in so
879: ** the mtl_parameters index is not used
880: */
881:
882: /* removed + 0 from where condition

Line 879: ** the mtl_parameters index is not used

875: **comparison in statement_temp2
876: ** 04SEP96 To remove full table scan on msii by using the
877: ** msii index on org_id and segment(s), add a (dummy)
878: ** join to mtl_parameters The + 0 has been put in so
879: ** the mtl_parameters index is not used
880: */
881:
882: /* removed + 0 from where condition
883: and clause of organization_id to fix bug 7459820 with base bug 7003119 */

Line 888: mtl_parameters mp

884: DSQL_statement2 := ' select msii.inventory_item_id,
885: msii.transaction_id,
886: msii.organization_id
887: from mtl_system_items_interface msii,
888: mtl_parameters mp
889: where msii.inventory_item_id <>
890: :l_item_id_bind
891: and set_process_id = :xset_id_bind
892: and msii.organization_id = mp.organization_id

Line 2027: from mtl_parameters

2023:
2024: -- validate lot_control_code
2025: lot_num_generation_val := NULL;
2026: select lot_number_generation into lot_num_generation_val
2027: from mtl_parameters
2028: where organization_id = cr.organization_id
2029: and rownum =1; /*NP 21DEC94 */
2030:
2031: -- Bug 3333917 : Message name corrected - Anmurali

Line 2057: from mtl_parameters

2053:
2054: -- validate lot_control_code
2055: lot_num_generation_val := NULL;
2056: select lot_number_generation into lot_num_generation_val
2057: from mtl_parameters
2058: where organization_id = cr.organization_id
2059: and rownum =1; /*NP 21DEC94 */
2060:
2061: --3296460:START_AUTO_LOT_NUMBER should be number.

Line 2118: from mtl_parameters

2114:
2115: -- validate serial_number_control_code
2116: ser_num_generation_val := NULL;
2117: select serial_number_generation into ser_num_generation_val
2118: from mtl_parameters
2119: where organization_id = cr.organization_id
2120: and rownum =1; /*NP 21DEC94 */
2121:
2122: if cr.serial_number_control_code = 2 and

Line 2147: from mtl_parameters

2143:
2144: -- validate serial_number_control_code
2145: ser_num_generation_val := NULL;
2146: select serial_number_generation into ser_num_generation_val
2147: from mtl_parameters
2148: where organization_id = cr.organization_id
2149: and rownum =1; /*NP 21DEC94 */
2150:
2151: if cr.serial_number_control_code = 2 and