eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;

154: ) is
155:
156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;

Line 159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;

155:
156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;

Line 160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;

156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;

Line 161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;

157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;

Line 162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;

158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;

Line 163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;

159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;

Line 164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;

160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;

Line 165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;

161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;

Line 166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;

162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;

Line 167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;

163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

Line 168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;

164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;

Line 169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;

165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;

Line 170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;

166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;

Line 171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;

Line 173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;

169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;
176: l_to_organization_id NUMBER;
177:

Line 178: --- [ Added code - l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER; ]

174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;
176: l_to_organization_id NUMBER;
177:
178: --- [ Added code - l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER; ]
179: l_lpn_id NUMBER;
180:
181: l_debug NUMBER;
182: --use to_organization if put away, from_organization if pick

Line 237: from WMS_TRANSACTIONS_TEMP mptt

233: ,mptt.grade_code
234: ,mptt.reservation_id
235: ,mptt.serial_number ---- [ Added code - ,mptt.serial_number ]
236: ,mptt.lpn_id
237: from WMS_TRANSACTIONS_TEMP mptt
238: where mptt.TRANSACTION_TEMP_ID = p_transaction_temp_id
239: and mptt.TYPE_CODE = p_type_code
240: and mptt.LINE_TYPE_CODE = 1
241: order by mptt.pp_transaction_temp_id

Line 1871: -- WMS_TRANSACTIONS_TEMP )

1867: -- at least one transaction detail record in
1868: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1869: -- and parameters p_transaction_temp_id and p_type_code
1870: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1871: -- WMS_TRANSACTIONS_TEMP )
1872: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1873: -- parameter p_strategy_id
1874: -- at least one strategy member record in
1875: -- WMS_STRATEGY_MEMBERS identified by parameter

Line 1943: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

1939: l_api_name constant varchar2(30) := 'Apply';
1940:
1941: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;
1942: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1943: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1944: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1945: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1946: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1947: l_grade_code VARCHAR2(150);

Line 2009: FROM WMS_TRANSACTIONS_TEMP

2005: l_tolerance_value NUMBER;
2006: -- 8809951 modified the cursor
2007: CURSOR c_output_exists IS
2008: SELECT 'Y'
2009: FROM WMS_TRANSACTIONS_TEMP
2010: WHERE TYPE_CODE = p_type_code
2011: AND LINE_TYPE_CODE = 2;
2012:
2013: begin