7206: END IF;
7207: BEGIN
7208: SELECT 1
7209: INTO l_chk_flag
7210: FROM dual
7211: WHERE EXISTS (SELECT 1
7212: FROM MTL_ONHAND_QUANTITIES_DETAIL
7213: WHERE LOCATOR_ID = P_LOCATOR_ID
7214: AND ORGANIZATION_ID = P_ORG_ID
7219: END IF;
7220: BEGIN
7221: SELECT 1
7222: INTO l_chk_flag
7223: FROM dual
7224: WHERE EXISTS (SELECT 1
7225: FROM MTL_ONHAND_QUANTITIES_DETAIL
7226: WHERE LOCATOR_ID = P_LOCATOR_ID
7227: AND ORGANIZATION_ID = P_ORG_ID
7322:
7323: BEGIN
7324: SELECT 1
7325: INTO l_chk_flag
7326: FROM dual
7327: WHERE EXISTS (
7328: -- Onhand
7329: SELECT 1
7330: FROM MTL_ONHAND_QUANTITIES_DETAIL
8092:
8093: BEGIN
8094: SELECT 1
8095: INTO l_chk_flag
8096: FROM dual
8097: WHERE EXISTS (
8098: SELECT 1
8099: FROM rcv_supply rs
8100: WHERE rs.to_locator_id = p_locator_id