APPS.AHL_PRD_MTLTXN_PVT dependencies on WIP_PARAMETERS

Line 1851: FROM wip_parameters

1847:
1848: -- Default Subinventory.
1849: CURSOR wip_params_cur (p_org_id IN NUMBER) IS
1850: SELECT default_pull_supply_subinv, default_pull_supply_locator_id
1851: FROM wip_parameters
1852: WHERE organization_id = p_org_id;
1853:
1854: CURSOR workorder_released_date_csr(p_wip_entity_id IN NUMBER) IS
1855: SELECT DATE_RELEASED FROM WIP_DISCRETE_JOBS

Line 1911: l_def_supply_subinv wip_parameters.default_pull_supply_subinv%TYPE;

1907: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
1908: l_quantity NUMBER;
1909: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
1910: l_visit_id NUMBER;
1911: l_def_supply_subinv wip_parameters.default_pull_supply_subinv%TYPE;
1912: l_def_supply_locator_id NUMBER;
1913:
1914: L_SCHED_START_DATE DATE;
1915:

Line 4322: WIP_PARAMETERS WIP,

4318: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
4319: BOM_DEPARTMENTS B,
4320: AHL_WORKORDER_OPERATIONS O,
4321: MTL_UNITS_OF_MEASURE_VL UOM,
4322: WIP_PARAMETERS WIP,
4323: MTL_ITEM_LOCATIONS_KFV L
4324: WHERE
4325: D.WORKORDER_ID = W.WORKORDER_ID AND
4326: W.MASTER_WORKORDER_FLAG = 'N' AND

Line 4683: WIP_PARAMETERS WIP,

4679: MTL_UNITS_OF_MEASURE_VL UOM,
4680: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4681: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
4682: MTL_ITEM_LOCATIONS MTL_LOC,
4683: WIP_PARAMETERS WIP,
4684: PER_ALL_PEOPLE_F PER
4685: WHERE
4686: TXNS.TRANSACTION_TYPE_ID = 35 AND
4687: TXNS.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND

Line 4763: WIP_PARAMETERS W

4759: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4760: AHL_VISITS_B V,
4761: AHL_VISIT_TASKS_B VT,
4762: AHL_WORKORDER_OPERATIONS F,
4763: WIP_PARAMETERS W
4764: WHERE
4765: A.INVENTORY_ITEM_ID=B.INVENTORY_ITEM_ID
4766: AND A.WORKORDER_OPERATION_ID=F.WORKORDER_OPERATION_ID
4767: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID

Line 5084: WIP_PARAMETERS P,

5080: FROM
5081: CSI_ITEM_INSTANCES CSI,
5082: MTL_SYSTEM_ITEMS_KFV I,
5083: AHL_SEARCH_WORKORDERS_v W,
5084: WIP_PARAMETERS P,
5085: MTL_UNITS_OF_MEASURE_VL UOM,
5086: MTL_ITEM_LOCATIONS D,
5087: MTL_PARAMETERS MP
5088: WHERE