[Home] [Help]
642: SELECT a.to_organization_id
643: , b.organization_code
644: , c.NAME
645: , a.intransit_type
646: FROM mtl_interorg_parameters a, mtl_parameters b, hr_all_organization_units c
647: WHERE a.from_organization_id = p_from_organization_id
648: AND a.to_organization_id = b.organization_id
649: AND a.to_organization_id = c.organization_id
650: AND a.internal_order_required_flag = 2
666: SELECT distinct mp.organization_id
667: , mp.organization_code
668: , hu.name organization_name
669: ,0
670: FROM mtl_parameters mp
671: , hr_organization_units hu
672: WHERE mp.organization_code LIKE (p_organization_code || '%')
673: and mp.organization_id = hu.organization_id order by 2;
674: END get_all_orgs;
1188: END IF;
1189:
1190: -- Fetch the all_different_Status from MTL_PARAMETER for the current organization and restrict
1191: -- the lot_status only if the parameter is set to 1.
1192: SELECT allow_different_status INTO l_allow_different_status FROM mtl_parameters WHERE organization_id = p_organization_id;
1193:
1194: IF p_status_id IS NOT NULL AND p_status_id <> 0
1195: AND NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) = 1 -- IF INV: Material Status Support is set to Yes
1196: AND l_allow_different_status = 1 THEN -- If Allow Different Lot status is set to 1
1940: l_negative_rcpt_code NUMBER;
1941: BEGIN
1942: SELECT negative_inv_receipt_code
1943: INTO l_negative_rcpt_code
1944: FROM mtl_parameters
1945: WHERE organization_id = p_organization_id;
1946:
1947: IF (l_negative_rcpt_code = 1) THEN
1948: -- Negative inventory balances allowed