DBA Data[Home] [Help]

APPS.INV_LOC_WMS_UTILS dependencies on DUAL

Line 7210: FROM dual

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

Line 7223: FROM dual

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

Line 7326: FROM dual

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

Line 8096: FROM dual

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