You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Default Bin Location DFF in Requisition Page based based on Source Subinventory?

CrownCastle is looking to create a DFF(Source Bin Locator) based on Sub Inventory Organization. Currently, I am seeing only these options :

Reference: 

Current Valueset Where Clause:

Where Clause:

ffv.flex_value_set_id = ffvs.flex_value_set_id
AND ffvs.flex_value_set_name = 'LT_BINS'
AND ffv.enabled_flag = 'Y'
and exists
(
select 1
from
inv_item_locations iil
where
1=1
and iil.LOCATOR_NAME = ffv.flex_value
and iil.SUBINVENTORY_CODE = :{PARAMETER} — Need to understand what parameter drives Source Subinventory?
)

Use Case:

We are trying create a Bin Locator DFF based on Source Subinventory. Currently, we are NOT seeing option to pass in Source Subinventory in the WHERE Clause of the query.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!