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.

APPS.WIP_POPULATE_TEMP dependencies on WIP_CONSTANTS

Line 115: p_entity_type) = WIP_CONSTANTS.YES

111: wro.wip_supply_type,
112: wro.required_quantity,
113: wro.quantity_issued,
114: p_assembly_quantity,
115: p_entity_type) = WIP_CONSTANTS.YES
116: AND WIP_COMPONENT.meets_criteria(
117: wro.operation_seq_num,
118: p_operation_seq_num,
119: wro.department_id,

Line 122: p_criteria_sub) = WIP_CONSTANTS.YES

118: p_operation_seq_num,
119: wro.department_id,
120: p_department_id,
121: wro.supply_subinventory,
122: p_criteria_sub) = WIP_CONSTANTS.YES
123: AND wdj.wip_entity_id = wro.wip_entity_id
124: AND wdj.organization_id = wro.organization_id
125: AND bd.department_id(+) = wro.department_id
126: AND bd.organization_id(+) = wro.organization_id

Line 133: WIP_CONSTANTS.SUBTRFR_ACTION, p_subinventory,

129: AND mum.uom_code = msi.primary_uom_code
130: AND msinv.organization_id(+) = wro.organization_id
131: AND msinv.secondary_inventory_name(+) =
132: decode(p_transaction_action_id,
133: WIP_CONSTANTS.SUBTRFR_ACTION, p_subinventory,
134: NVL(wro.supply_subinventory, p_subinventory))
135: AND mil.organization_id(+) = wro.organization_id
136: AND mil.inventory_location_id(+) =
137: decode(p_transaction_action_id,

Line 138: WIP_CONSTANTS.SUBTRFR_ACTION, p_locator_id,

134: NVL(wro.supply_subinventory, p_subinventory))
135: AND mil.organization_id(+) = wro.organization_id
136: AND mil.inventory_location_id(+) =
137: decode(p_transaction_action_id,
138: WIP_CONSTANTS.SUBTRFR_ACTION, p_locator_id,
139: NVL(wro.supply_locator_id, p_locator_id))
140: AND mp.organization_id = wro.organization_id
141: ORDER BY
142: wro.operation_seq_num;

Line 216: p_entity_type) = WIP_CONSTANTS.YES

212: wro.wip_supply_type,
213: wro.required_quantity,
214: wro.quantity_issued,
215: NULL,
216: p_entity_type) = WIP_CONSTANTS.YES
217: AND WIP_COMPONENT.meets_criteria(
218: wro.operation_seq_num,
219: p_operation_seq_num,
220: wro.department_id,

Line 223: p_criteria_sub) = WIP_CONSTANTS.YES

219: p_operation_seq_num,
220: wro.department_id,
221: p_department_id,
222: wro.supply_subinventory,
223: p_criteria_sub) = WIP_CONSTANTS.YES
224: AND bd.department_id(+) = wro.department_id
225: AND bd.organization_id(+) = wro.organization_id
226: AND msi.inventory_item_id = wro.inventory_item_id
227: AND msi.organization_id = wro.organization_id

Line 232: WIP_CONSTANTS.SUBTRFR_ACTION, p_subinventory,

228: AND mum.uom_code = msi.primary_uom_code
229: AND msinv.organization_id(+) = wro.organization_id
230: AND msinv.secondary_inventory_name(+) =
231: decode(p_transaction_action_id,
232: WIP_CONSTANTS.SUBTRFR_ACTION, p_subinventory,
233: NVL(wro.supply_subinventory, p_subinventory))
234: AND mil.organization_id(+) = wro.organization_id
235: AND mil.inventory_location_id(+) =
236: decode(p_transaction_action_id,

Line 237: WIP_CONSTANTS.SUBTRFR_ACTION, p_locator_id,

233: NVL(wro.supply_subinventory, p_subinventory))
234: AND mil.organization_id(+) = wro.organization_id
235: AND mil.inventory_location_id(+) =
236: decode(p_transaction_action_id,
237: WIP_CONSTANTS.SUBTRFR_ACTION, p_locator_id,
238: NVL(wro.supply_locator_id, p_locator_id))
239: AND mp.organization_id = wro.organization_id
240: /* Fix for bug 2570492 Adding filtering by status_type */
241: AND status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)

Line 241: AND status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)

237: WIP_CONSTANTS.SUBTRFR_ACTION, p_locator_id,
238: NVL(wro.supply_locator_id, p_locator_id))
239: AND mp.organization_id = wro.organization_id
240: /* Fix for bug 2570492 Adding filtering by status_type */
241: AND status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)
242: GROUP BY
243: wro.inventory_item_id,
244: msinv.secondary_inventory_name,
245: bd.department_id,

Line 285: IF p_transaction_action_id = WIP_CONSTANTS.SUBTRFR_ACTION THEN

281: X_COMMIT_COUNTER := 0;
282:
283: /* Source Type and Source are set differently for Subinventory Replen */
284:
285: IF p_transaction_action_id = WIP_CONSTANTS.SUBTRFR_ACTION THEN
286: /*Start: Bug 6460181: Instead of a constant value for x_transaction_source_type_id, the value is selected from mtl_transaction_type table*/
287:
288: SELECT transaction_source_type_id
289: into x_transaction_source_type_id

Line 311: IF p_entity_type in (WIP_CONSTANTS.DISCRETE,WIP_CONSTANTS.LOTBASED,6) THEN

307: x_released_revs_meaning
308: );
309:
310: --6 is eAM job
311: IF p_entity_type in (WIP_CONSTANTS.DISCRETE,WIP_CONSTANTS.LOTBASED,6) THEN
312: FOR C IN CDIS LOOP
313:
314: x_dummy := FND_FLEX_KEYVAL.validate_ccid(
315: appl_short_name => 'INV',

Line 357: IF C.revision_qty_control_code = WIP_CONSTANTS.REV THEN

353: x_locator_id := null; --no locator when sub is not populated
354: x_locator_segments := NULL;
355: END IF;
356:
357: IF C.revision_qty_control_code = WIP_CONSTANTS.REV THEN
358: BOM_REVISIONS.Get_Revision
359: (type => 'PART',
360: eco_status => x_released_revs_meaning,
361: examine_type => 'ALL',

Line 382: (WIP_CONSTANTS.RETNEGC_ACTION,

378: AND C.serial_control_code <> 1)
379: OR (C.transaction_quantity = 0
380: AND p_assembly_quantity IS NOT NULL
381: AND p_transaction_action_id IN
382: (WIP_CONSTANTS.RETNEGC_ACTION,
383: WIP_CONSTANTS.RETCOMP_ACTION)) THEN
384: x_wip_commit_flag := 'N';
385: X_COMMIT_COUNTER := X_COMMIT_COUNTER + 1;
386: ELSE

Line 383: WIP_CONSTANTS.RETCOMP_ACTION)) THEN

379: OR (C.transaction_quantity = 0
380: AND p_assembly_quantity IS NOT NULL
381: AND p_transaction_action_id IN
382: (WIP_CONSTANTS.RETNEGC_ACTION,
383: WIP_CONSTANTS.RETCOMP_ACTION)) THEN
384: x_wip_commit_flag := 'N';
385: X_COMMIT_COUNTER := X_COMMIT_COUNTER + 1;
386: ELSE
387: x_wip_commit_flag := 'Y';

Line 616: IF C.revision_qty_control_code = WIP_CONSTANTS.REV THEN

612: --x_locator_segments := FND_FLEX_KEYVAL.concatenated_values;
613: END IF;
614: END IF;
615:
616: IF C.revision_qty_control_code = WIP_CONSTANTS.REV THEN
617: BOM_REVISIONS.Get_Revision
618: (type => 'PART',
619: eco_status => x_released_revs_meaning,
620: examine_type => 'ALL',

Line 641: (WIP_CONSTANTS.RETNEGC_ACTION,

637: AND C.serial_control_code <> 1)
638: OR (C.transaction_quantity = 0
639: AND p_assembly_quantity IS NOT NULL
640: AND p_transaction_action_id IN
641: (WIP_CONSTANTS.RETNEGC_ACTION,
642: WIP_CONSTANTS.RETCOMP_ACTION)) THEN
643: x_wip_commit_flag := 'N';
644: X_COMMIT_COUNTER := X_COMMIT_COUNTER + 1;
645: ELSE

Line 642: WIP_CONSTANTS.RETCOMP_ACTION)) THEN

638: OR (C.transaction_quantity = 0
639: AND p_assembly_quantity IS NOT NULL
640: AND p_transaction_action_id IN
641: (WIP_CONSTANTS.RETNEGC_ACTION,
642: WIP_CONSTANTS.RETCOMP_ACTION)) THEN
643: x_wip_commit_flag := 'N';
644: X_COMMIT_COUNTER := X_COMMIT_COUNTER + 1;
645: ELSE
646: x_wip_commit_flag := 'Y';