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.WSMPOPRN dependencies on WIP_CONSTANTS

Line 441: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

437: SEQ.OPERATION_SEQUENCE_ID,
438: SEQ.STANDARD_OPERATION_ID,
439: SEQ.DEPARTMENT_ID,
440: SEQ.OPERATION_DESCRIPTION,
441: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
442: 0, 0, 0, 0, 0, 0,
443: DJ.SCHEDULED_START_DATE,
444: DJ.SCHEDULED_COMPLETION_DATE,
445: DJ.SCHEDULED_START_DATE,

Line 643: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

639: NULL, --SEQ.OPERATION_SEQUENCE_ID,
640: bso.STANDARD_OPERATION_ID,
641: bso.DEPARTMENT_ID,
642: bso.OPERATION_DESCRIPTION,
643: ROUND(DJ.Start_Quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
644: 0, 0, 0, 0, 0, 0,
645: DJ.SCHEDULED_START_DATE,
646: DJ.SCHEDULED_COMPLETION_DATE,
647: DJ.SCHEDULED_START_DATE,

Line 1107: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,

1103: p_initMsgList => fnd_api.g_true,
1104: p_endDebug => fnd_api.g_true,
1105: p_orgID => X_Organization_Id,
1106: p_wipEntityID => X_Wip_Entity_Id,
1107: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,
1108: p_startDate => l_infi_start_date,
1109: p_endDate => null,
1110: p_opSeqNum => -X_To_Op,
1111: p_scheQuantity => p_txn_quantity,

Line 1539: WIP_CONSTANTS.SCRAP,

1535:
1536: l_stat_num := 5;
1537: BEGIN
1538: SELECT operation_seq_num,
1539: WIP_CONSTANTS.SCRAP,
1540: nvl(to_number(STANDARD_OPERATION_ID),0),
1541: ml.meaning
1542: INTO l_op,
1543: l_step,

Line 1557: AND ml.lookup_code = WIP_CONSTANTS.SCRAP;

1553: AND quantity_scrapped = quantity_completed
1554: AND quantity_completed > 0
1555: AND count_point_type <> 3
1556: AND ml.lookup_type = 'WIP_INTRAOPERATION_STEP'
1557: AND ml.lookup_code = WIP_CONSTANTS.SCRAP;
1558:
1559: p_current_op_seq := l_op;
1560: p_current_op_step := l_step;
1561:

Line 1573: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),

1569:
1570: l_stat_num :=10;
1571: SELECT operation_seq_num,
1572: decode(quantity_in_queue, 0,
1573: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),
1574: WIP_CONSTANTS.QUEUE),
1575: nvl(to_number(STANDARD_OPERATION_ID),0),
1576: ml.meaning
1577: INTO l_op,

Line 1574: WIP_CONSTANTS.QUEUE),

1570: l_stat_num :=10;
1571: SELECT operation_seq_num,
1572: decode(quantity_in_queue, 0,
1573: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),
1574: WIP_CONSTANTS.QUEUE),
1575: nvl(to_number(STANDARD_OPERATION_ID),0),
1576: ml.meaning
1577: INTO l_op,
1578: l_step,

Line 1591: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),

1587: OR quantity_waiting_to_move <> 0)
1588: AND ml.lookup_type = 'WIP_INTRAOPERATION_STEP'
1589: AND ml.lookup_code =
1590: decode(quantity_in_queue, 0,
1591: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),
1592: WIP_CONSTANTS.QUEUE);
1593:
1594: p_current_op_seq := l_op;
1595: p_current_op_step := l_step;

Line 1592: WIP_CONSTANTS.QUEUE);

1588: AND ml.lookup_type = 'WIP_INTRAOPERATION_STEP'
1589: AND ml.lookup_code =
1590: decode(quantity_in_queue, 0,
1591: decode(quantity_running, 0, WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.RUN),
1592: WIP_CONSTANTS.QUEUE);
1593:
1594: p_current_op_seq := l_op;
1595: p_current_op_step := l_step;
1596: l_stat_num := 20;

Line 1745: IF x_step = WIP_CONSTANTS.TOMOVE THEN

1741: FUNCTION get_next_mandatory_step(x_step IN NUMBER, x_flag IN NUMBER)
1742: RETURN NUMBER IS
1743: BEGIN
1744:
1745: IF x_step = WIP_CONSTANTS.TOMOVE THEN
1746: return(0);
1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN
1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN

Line 1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN

1743: BEGIN
1744:
1745: IF x_step = WIP_CONSTANTS.TOMOVE THEN
1746: return(0);
1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN
1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN

Line 1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN

1745: IF x_step = WIP_CONSTANTS.TOMOVE THEN
1746: return(0);
1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN
1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN

Line 1750: return(WIP_CONSTANTS.TOMOVE);

1746: return(0);
1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN
1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);

Line 1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN

1747: ELSIF x_step = WIP_CONSTANTS.RUN and x_flag < 5 THEN
1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN

Line 1752: return(WIP_CONSTANTS.RUN);

1748: return(0);
1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN
1756: return(WIP_CONSTANTS.QUEUE);

Line 1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN

1749: ELSIF x_step = WIP_CONSTANTS.RUN THEN
1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN
1756: return(WIP_CONSTANTS.QUEUE);
1757: ELSIF x_step = 0 AND x_flag IN (3,7) THEN

Line 1754: return(WIP_CONSTANTS.TOMOVE);

1750: return(WIP_CONSTANTS.TOMOVE);
1751: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (3,4,7,8) THEN
1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN
1756: return(WIP_CONSTANTS.QUEUE);
1757: ELSIF x_step = 0 AND x_flag IN (3,7) THEN
1758: return(WIP_CONSTANTS.RUN);

Line 1756: return(WIP_CONSTANTS.QUEUE);

1752: return(WIP_CONSTANTS.RUN);
1753: ELSIF x_step = WIP_CONSTANTS.QUEUE and x_flag IN (5,6) THEN
1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN
1756: return(WIP_CONSTANTS.QUEUE);
1757: ELSIF x_step = 0 AND x_flag IN (3,7) THEN
1758: return(WIP_CONSTANTS.RUN);
1759: ELSIF x_step = 0 and x_flag = 5 THEN
1760: return(WIP_CONSTANTS.TOMOVE);

Line 1758: return(WIP_CONSTANTS.RUN);

1754: return(WIP_CONSTANTS.TOMOVE);
1755: ELSIF x_step = 0 AND x_flag IN (2,4,6,8) THEN
1756: return(WIP_CONSTANTS.QUEUE);
1757: ELSIF x_step = 0 AND x_flag IN (3,7) THEN
1758: return(WIP_CONSTANTS.RUN);
1759: ELSIF x_step = 0 and x_flag = 5 THEN
1760: return(WIP_CONSTANTS.TOMOVE);
1761: ELSE
1762: return(0);

Line 1760: return(WIP_CONSTANTS.TOMOVE);

1756: return(WIP_CONSTANTS.QUEUE);
1757: ELSIF x_step = 0 AND x_flag IN (3,7) THEN
1758: return(WIP_CONSTANTS.RUN);
1759: ELSIF x_step = 0 and x_flag = 5 THEN
1760: return(WIP_CONSTANTS.TOMOVE);
1761: ELSE
1762: return(0);
1763: END IF;
1764:

Line 2325: --ROUND(nvl(p_txn_quantity, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

2321: WCO.STANDARD_OPERATION_ID,
2322: WCO.DEPARTMENT_ID,
2323: WCO.OPERATION_DESCRIPTION,
2324: /*bug 3686872 added nvl(WCO.RECO_SCHEDULED_QUANTITY to the code below removed p_txn_quantity*/
2325: --ROUND(nvl(p_txn_quantity, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2326: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2327: 0, 0, 0, 0, 0, 0,
2328: decode(recommended, 'Y', nvl(RECO_START_DATE, p_txn_date), p_txn_date), --move_enh? populate the reco dates for planned op or ...
2329: decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, p_txn_date), p_txn_date),

Line 2326: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

2322: WCO.DEPARTMENT_ID,
2323: WCO.OPERATION_DESCRIPTION,
2324: /*bug 3686872 added nvl(WCO.RECO_SCHEDULED_QUANTITY to the code below removed p_txn_quantity*/
2325: --ROUND(nvl(p_txn_quantity, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2326: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, 0), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2327: 0, 0, 0, 0, 0, 0,
2328: decode(recommended, 'Y', nvl(RECO_START_DATE, p_txn_date), p_txn_date), --move_enh? populate the reco dates for planned op or ...
2329: decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, p_txn_date), p_txn_date),
2330: decode(recommended, 'Y', nvl(RECO_START_DATE, p_txn_date), p_txn_date),

Line 2504: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION)*p_txn_quantity,

2500: WCRO.WIP_SUPPLY_TYPE,
2501: decode(WCRO.recommended, 'Y', Nvl(WCRO.reco_date_required, p_txn_date), p_txn_date),
2502: --move enh 115.77 component yield no longer factored in
2503: /* round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
2504: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION)*p_txn_quantity,
2505: round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
2506: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2507: */
2508: --bug 3587239 Round the required quantity to 6 places

Line 2506: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

2502: --move enh 115.77 component yield no longer factored in
2503: /* round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
2504: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION)*p_txn_quantity,
2505: round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
2506: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
2507: */
2508: --bug 3587239 Round the required quantity to 6 places
2509: WCRO.basis_type, --LBM enh
2510: --Bug 5236684:Component yield factor should include the yield of the source phantom also.

Line 3090: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

3086: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WSMPCNST.NUMBER_OF_DECIMALS)*p_txn_quantity,
3087: */
3088:
3089: /* round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
3090: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
3091: */
3092: --bug 3587239 Round the required quantity to 6 places
3093: WCRO.basis_type, --LBM enh
3094: -- Component shrinkage

Line 3615: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,

3611: p_initMsgList => fnd_api.g_true,
3612: p_endDebug => fnd_api.g_true,
3613: p_orgID => p_org_id,
3614: p_wipEntityID => p_wip_entity_id,
3615: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,
3616: p_startDate => l_infi_start_date,
3617: p_endDate => null,
3618: p_opSeqNum => -p_to_job_op_seq_num,
3619: p_scheQuantity => p_scheQuantity,