[Home] [Help]
664: SELECT a.to_organization_id
665: , b.organization_code
666: , c.NAME
667: , a.intransit_type
668: FROM mtl_interorg_parameters a, mtl_parameters b, hr_all_organization_units c
669: WHERE a.from_organization_id = p_from_organization_id
670: AND a.to_organization_id = b.organization_id
671: AND a.to_organization_id = c.organization_id
672: AND a.internal_order_required_flag = 2
688: SELECT distinct mp.organization_id
689: , mp.organization_code
690: , hu.name organization_name
691: ,0
692: FROM mtl_parameters mp
693: , hr_organization_units hu
694: WHERE mp.organization_code LIKE (p_organization_code || '%')
695: and mp.organization_id = hu.organization_id order by 2;
696: END get_all_orgs;
1212: END IF;
1213:
1214: -- Fetch the all_different_Status from MTL_PARAMETER for the current organization and restrict
1215: -- the lot_status only if the parameter is set to 1.
1216: SELECT allow_different_status INTO l_allow_different_status FROM mtl_parameters WHERE organization_id = p_organization_id;
1217:
1218: IF p_status_id IS NOT NULL AND p_status_id <> 0
1219: AND NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) = 1 -- IF INV: Material Status Support is set to Yes
1220: AND l_allow_different_status = 1 THEN -- If Allow Different Lot status is set to 1
1964: l_negative_rcpt_code NUMBER;
1965: BEGIN
1966: SELECT negative_inv_receipt_code
1967: INTO l_negative_rcpt_code
1968: FROM mtl_parameters
1969: WHERE organization_id = p_organization_id;
1970:
1971: IF (l_negative_rcpt_code = 1) THEN
1972: -- Negative inventory balances allowed