DBA Data[Home] [Help]

APPS.INV_LOC_WMS_UTILS dependencies on DUAL

Line 7730: FROM dual

7726: END IF;
7727: BEGIN
7728: SELECT 1
7729: INTO l_chk_flag
7730: FROM dual
7731: WHERE EXISTS (SELECT 1
7732: FROM MTL_ONHAND_QUANTITIES_DETAIL
7733: WHERE LOCATOR_ID = P_LOCATOR_ID
7734: AND ORGANIZATION_ID = P_ORG_ID

Line 7743: FROM dual

7739: END IF;
7740: BEGIN
7741: SELECT 1
7742: INTO l_chk_flag
7743: FROM dual
7744: WHERE EXISTS (SELECT 1
7745: FROM MTL_ONHAND_QUANTITIES_DETAIL
7746: WHERE LOCATOR_ID = P_LOCATOR_ID
7747: AND ORGANIZATION_ID = P_ORG_ID

Line 7846: FROM dual

7842:
7843: BEGIN
7844: SELECT 1
7845: INTO l_chk_flag
7846: FROM dual
7847: WHERE EXISTS (
7848: -- Onhand
7849: SELECT 1
7850: FROM MTL_ONHAND_QUANTITIES_DETAIL

Line 8618: FROM dual

8614:
8615: BEGIN
8616: SELECT 1
8617: INTO l_chk_flag
8618: FROM dual
8619: WHERE EXISTS (
8620: SELECT 1
8621: FROM rcv_supply rs
8622: WHERE rs.to_locator_id = p_locator_id