DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_STRATEGY_MAT_TXN_TMP_V

Line 200: ,wms_strategy_mat_txn_tmp_v mpsmttv

196: ,mpsmttv.transaction_uom
197: ,msi.primary_uom_code
198: ,msi.secondary_uom_code
199: from mtl_system_items msi
200: ,wms_strategy_mat_txn_tmp_v mpsmttv
201: where msi.organization_id =
202: decode(p_type_code, 1, mpsmttv.to_organization_id,
203: mpsmttv.from_organization_id)
204: and msi.inventory_item_id = mpsmttv.inventory_item_id

Line 353: 'WMS_STRATEGY_MAT_TXN_TMP_V could not be found. ' ||

349: -- raise no_data_found;
350: If (l_debug = 1) then
351: log_event(l_api_name, 'no_input_head',
352: 'The general input information stored in ' ||
353: 'WMS_STRATEGY_MAT_TXN_TMP_V could not be found. ' ||
354: 'Detailing will fail.');
355: End if;
356: end if;
357: close inphead;

Line 855: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely

851: -- assignments to business objects.
852: -- Calls stub procedure to search for strategy assignments in a
853: -- customer-defined manner before actually following his own
854: -- algorithm to determine the valid strategy.
855: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
856: -- identified by parameters p_transaction_temp_id and
857: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
858: -- Parameters :
859: -- p_api_version in number required

Line 946: from WMS_STRATEGY_MAT_TXN_TMP_V mpsmttv

942: -- cursor for getting actual inventory org to search for strategy
943: cursor input is
944: select decode(p_type_code, 1, mpsmttv.TO_ORGANIZATION_ID,
945: mpsmttv.FROM_ORGANIZATION_ID) organization_id
946: from WMS_STRATEGY_MAT_TXN_TMP_V mpsmttv
947: where mpsmttv.LINE_ID = p_transaction_temp_id
948: and mpsmttv.TYPE_CODE = p_type_code;
949:
950: --cursor for getting org for cost group search

Line 1709: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely

1705: -- API name : Apply
1706: -- Type : Private
1707: -- Function : Applies a pick or put away strategy to the given transaction
1708: -- or reservation input parameters and creates recommendations
1709: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
1710: -- identified by parameters p_transaction_temp_id and
1711: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1712: -- at least one transaction detail record in
1713: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1