APPS.INVPVHDR dependencies on MTL_PARAMETERS

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

711: ** ensure that they have the same item id
712: ** 08-APR-96 This code now completely rewritten using
713: ** dynamic sql.
714: ** 04SEP96 To remove full table scan on msi by using the msi index
715: ** on org_id and segment(s), add a (dummy) join to mtl_parameters
716: ** The + 0 has been put in so the mtl_parameters index is not used
717: */
718: select count(*)
719: into is_master_org

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

712: ** 08-APR-96 This code now completely rewritten using
713: ** dynamic sql.
714: ** 04SEP96 To remove full table scan on msi by using the msi index
715: ** on org_id and segment(s), add a (dummy) join to mtl_parameters
716: ** The + 0 has been put in so the mtl_parameters index is not used
717: */
718: select count(*)
719: into is_master_org
720: from mtl_parameters

Line 720: from mtl_parameters

716: ** The + 0 has been put in so the mtl_parameters index is not used
717: */
718: select count(*)
719: into is_master_org
720: from mtl_parameters
721: where organization_id = cr.organization_id
722: and master_organization_id = cr.organization_id ;
723:
724: If (is_master_org = 1) then

Line 727: from mtl_parameters

723:
724: If (is_master_org = 1) then
725: select count(*)
726: into no_of_masterorgs
727: from mtl_parameters
728: where organization_id = master_organization_id ;
729:
730: If (no_of_masterorgs > 1) then
731: BEGIN /* PLSQL Block1 */

Line 738: mtl_parameters mp

734: END IF;
735:
736: DSQL_statement1 := 'select distinct msi.inventory_item_id
737: from mtl_system_items msi,
738: mtl_parameters mp
739: where msi.organization_id <>
740: :organization_id_bind
741: and msi.inventory_item_id <> :l_item_id_bind
742: and msi.organization_id = mp.organization_id + 0

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

856: **a big resource hog, because of nvl to nvl
857: **comparison in statement_temp2
858: ** 04SEP96 To remove full table scan on msii by using the
859: ** msii index on org_id and segment(s), add a (dummy)
860: ** join to mtl_parameters The + 0 has been put in so
861: ** the mtl_parameters index is not used
862: */
863:
864: DSQL_statement2 := ' select msii.inventory_item_id,

Line 861: ** the mtl_parameters index is not used

857: **comparison in statement_temp2
858: ** 04SEP96 To remove full table scan on msii by using the
859: ** msii index on org_id and segment(s), add a (dummy)
860: ** join to mtl_parameters The + 0 has been put in so
861: ** the mtl_parameters index is not used
862: */
863:
864: DSQL_statement2 := ' select msii.inventory_item_id,
865: msii.transaction_id,

Line 868: mtl_parameters mp

864: DSQL_statement2 := ' select msii.inventory_item_id,
865: msii.transaction_id,
866: msii.organization_id
867: from mtl_system_items_interface msii,
868: mtl_parameters mp
869: where msii.inventory_item_id <>
870: :l_item_id_bind
871: and set_process_id = :xset_id_bind
872: and msii.organization_id = mp.organization_id + 0

Line 1974: from mtl_parameters

1970:
1971: -- validate lot_control_code
1972: lot_num_generation_val := NULL;
1973: select lot_number_generation into lot_num_generation_val
1974: from mtl_parameters
1975: where organization_id = cr.organization_id
1976: and rownum =1; /*NP 21DEC94 */
1977:
1978: -- Bug 3333917 : Message name corrected - Anmurali

Line 2004: from mtl_parameters

2000:
2001: -- validate lot_control_code
2002: lot_num_generation_val := NULL;
2003: select lot_number_generation into lot_num_generation_val
2004: from mtl_parameters
2005: where organization_id = cr.organization_id
2006: and rownum =1; /*NP 21DEC94 */
2007:
2008: --3296460:START_AUTO_LOT_NUMBER should be number.

Line 2065: from mtl_parameters

2061:
2062: -- validate serial_number_control_code
2063: ser_num_generation_val := NULL;
2064: select serial_number_generation into ser_num_generation_val
2065: from mtl_parameters
2066: where organization_id = cr.organization_id
2067: and rownum =1; /*NP 21DEC94 */
2068:
2069: if cr.serial_number_control_code = 2 and

Line 2094: from mtl_parameters

2090:
2091: -- validate serial_number_control_code
2092: ser_num_generation_val := NULL;
2093: select serial_number_generation into ser_num_generation_val
2094: from mtl_parameters
2095: where organization_id = cr.organization_id
2096: and rownum =1; /*NP 21DEC94 */
2097:
2098: if cr.serial_number_control_code = 2 and