6520: --check the material status, and see if a sub transfer is allowed
6521: --in the source LPN sub/loc. If it is not, that you cannot load the
6522: --LPN
6523: IF (p_mode = 2 AND x_lpn_context = 1) THEN
6524: IF (inv_material_status_grp.is_status_applicable('TRUE',
6525: NULL,
6526: 2,--subtransfer
6527: NULL,
6528: NULL,
6532: l_lpn_loc,
6533: NULL,
6534: NULL,
6535: 'Z') <> 'Y' OR
6536: inv_material_status_grp.is_status_applicable('TRUE',
6537: NULL,
6538: 2,--Sub Transfer
6539: NULL,
6540: NULL,
12529: )
12530: )
12531: )
12532: )
12533: AND inv_material_status_grp.is_status_applicable('TRUE',
12534: NULL,
12535: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
12536: NULL,
12537: NULL,
12541: wlpn.locator_id,
12542: NULL,
12543: NULL,
12544: 'Z') = 'Y'
12545: AND inv_material_status_grp.is_status_applicable('TRUE',
12546: NULL,
12547: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
12548: NULL,
12549: NULL,
12889: )
12890: )
12891: )
12892: )
12893: AND inv_material_status_grp.is_status_applicable
12894: ('TRUE',NULL,inv_globals.g_type_container_pack,
12895: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
12896: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
12897: AND inv_material_status_grp.is_status_applicable
12893: AND inv_material_status_grp.is_status_applicable
12894: ('TRUE',NULL,inv_globals.g_type_container_pack,
12895: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
12896: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
12897: AND inv_material_status_grp.is_status_applicable
12898: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,
12899: NULL,p_organization_id,NULL,wlpn.subinventory_code,
12900: wlpn.locator_id,NULL,NULL,'L') = 'Y'
12901: )
14502: DEBUG(' p_sub => '||p_sub,l_proc_name, 4);
14503: DEBUG(' p_loc => '||p_loc,l_proc_name, 4);
14504: END IF;
14505:
14506: IF (inv_material_status_grp.is_status_applicable('TRUE',
14507: NULL,
14508: 2,--subtransfer
14509: NULL,
14510: NULL,
14514: p_loc,
14515: NULL,
14516: NULL,
14517: 'Z') ='Y' AND
14518: inv_material_status_grp.is_status_applicable('TRUE',
14519: NULL,
14520: 2,--Sub Transfer
14521: NULL,
14522: NULL,