DBA Data[Home] [Help]

APPS.WSH_PR_PICKING_OBJECTS dependencies on MTL_DEMAND

Line 300: FROM MTL_DEMAND

296: x_order_line_id IN BINARY_INTEGER,
297: x_delivery IN BINARY_INTEGER,
298: x_autodetail_group_id IN BINARY_INTEGER) IS
299: SELECT DISTINCT SUBINVENTORY
300: FROM MTL_DEMAND
301: WHERE DEMAND_SOURCE_HEADER_ID = x_ccid
302: AND DEMAND_SOURCE_TYPE IN (2,8)
303: AND DEMAND_SOURCE_LINE = to_char(x_order_line_id)
304: AND DEMAND_SOURCE_DELIVERY = to_char(x_delivery)

Line 314: FROM MTL_DEMAND

310: CURSOR nores_sub (x_ccid IN BINARY_INTEGER,
311: x_order_line_id IN BINARY_INTEGER,
312: x_delivery IN BINARY_INTEGER) IS
313: SELECT DISTINCT SUBINVENTORY
314: FROM MTL_DEMAND
315: WHERE DEMAND_SOURCE_HEADER_ID = x_ccid
316: AND DEMAND_SOURCE_TYPE IN (2,8)
317: AND DEMAND_SOURCE_LINE = to_char(x_order_line_id)
318: AND DEMAND_SOURCE_DELIVERY = to_char(x_delivery)

Line 1460: FROM MTL_DEMAND D

1456: D.SUPPLY_SOURCE_TYPE,
1457: p_transactable_flag,
1458: D.ORGANIZATION_ID,
1459: 'NEW'
1460: FROM MTL_DEMAND D
1461: WHERE D.DEMAND_SOURCE_HEADER_ID = p_ccid
1462: AND D.DEMAND_SOURCE_TYPE IN (2,8)
1463: AND D.DEMAND_SOURCE_LINE = to_char(p_order_line_id)
1464: AND D.DEMAND_SOURCE_DELIVERY = to_char(p_delivery)

Line 1552: FROM MTL_DEMAND D

1548: D.SUPPLY_SOURCE_TYPE,
1549: p_transactable_flag,
1550: D.ORGANIZATION_ID,
1551: 'NEW'
1552: FROM MTL_DEMAND D
1553: WHERE D.DEMAND_SOURCE_HEADER_ID = p_ccid
1554: AND D.DEMAND_SOURCE_TYPE IN (2,8)
1555: AND D.DEMAND_SOURCE_LINE = to_char(p_order_line_id)
1556: AND D.DEMAND_SOURCE_DELIVERY = to_char(p_delivery)