APPS.WMA_MOVE dependencies on WIP_OPERATIONS

Line 336: FROM wip_operations

332: p_txnType = WIP_CONSTANTS.RET_TXN) THEN -- Easy Complete/Return
333: -- get the last operation to pass to backflush processor
334: SELECT NVL(MAX(operation_seq_num), 1)
335: INTO l_maxOpSeqNum
336: FROM wip_operations
337: WHERE wip_entity_id = p_jobID;
338:
339: IF(p_txnType = WIP_CONSTANTS.COMP_TXN) THEN
340: l_bf_qty := p_moveQty;

Line 497: FROM wip_operations

493: l_last_bf_op := -1;
494: l_bf_qty := 0;
495: SELECT MIN(operation_seq_num)
496: INTO l_first_op
497: FROM wip_operations
498: WHERE wip_entity_id = p_jobID;
499:
500: bf_require(p_jobID => p_jobID,
501: p_fm_op => l_first_op,

Line 787: wip_operations_info.derive_info(

783: return false;
784: end if;
785:
786: -- derive the operation related information based on sequence number (From)
787: wip_operations_info.derive_info(
788: p_org_id => parameters.environment.orgID,
789: p_wip_entity_id => parameters.wipEntityID,
790: p_first_schedule_id => null,
791: p_operation_seq_num => parameters.fmOpSeqNum,

Line 800: wip_operations_info.derive_info(

796: p_next_op_seq_num => fmNextOpSeq,
797: p_operation_exists => fmOpExists);
798:
799: -- derive the operation related information based on sequence number (To)
800: wip_operations_info.derive_info(
801: p_org_id => parameters.environment.orgID,
802: p_wip_entity_id => parameters.wipEntityID,
803: p_first_schedule_id => null,
804: p_operation_seq_num => parameters.toOpSeqNum,

Line 934: FROM wip_operations wop

930: -1, 1),
931: -1, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
932: 0, -1)) txn_qty,
933: MAX(wop.operation_seq_num) last_op
934: FROM wip_operations wop
935: WHERE wop.wip_entity_id = p_jobID
936: AND ((wop.operation_seq_num = p_fm_op AND
937: p_fm_step = WIP_CONSTANTS.SCRAP)
938: OR

Line 946: FROM wip_operations wop

942:
943: CURSOR c_first_bf_op IS
944:
945: SELECT MIN(wop.operation_seq_num) first_op
946: FROM wip_operations wop
947: WHERE wop.wip_entity_id = p_jobID
948: AND wop.operation_seq_num >
949: DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
950: 0, DECODE(SIGN(p_to_step - WIP_CONSTANTS.SCRAP),

Line 1080: FROM wip_operations wop

1076: -1),
1077: 1, 1,
1078: -1,-1) txn_qty,
1079: MAX(wop.operation_seq_num) last_op
1080: FROM wip_operations wop
1081: WHERE wop.wip_entity_id = p_jobID
1082: AND DECODE(SIGN(DECODE(SIGN(p_to_op - p_fm_op),
1083: -1, p_fm_step,
1084: 1, p_to_step,

Line 1107: FROM wip_operations wop

1103:
1104: CURSOR c_first_bf_op IS
1105:
1106: SELECT MIN(wop.operation_seq_num) first_op
1107: FROM wip_operations wop
1108: WHERE wop.wip_entity_id = p_jobID
1109: AND wop.operation_seq_num >
1110: (SELECT NVL(MAX(wop1.operation_seq_num), 0)
1111: FROM wip_operations wop1

Line 1111: FROM wip_operations wop1

1107: FROM wip_operations wop
1108: WHERE wop.wip_entity_id = p_jobID
1109: AND wop.operation_seq_num >
1110: (SELECT NVL(MAX(wop1.operation_seq_num), 0)
1111: FROM wip_operations wop1
1112: WHERE wop1.wip_entity_id = p_jobID
1113: AND DECODE(SIGN(DECODE(SIGN(p_to_op - p_fm_op),
1114: -1, p_to_step,
1115: 1, p_fm_step,

Line 1139: FROM wip_operations wop

1135:
1136: SELECT MIN(wop.operation_seq_num) first_op,
1137: p_to_op last_op,
1138: p_moveQty txn_qty
1139: FROM wip_operations wop
1140: WHERE wop.wip_entity_id = p_jobID
1141: AND wop.operation_seq_num >
1142: (SELECT NVL(MAX(wop1.operation_seq_num),0)
1143: FROM wip_operations wop1

Line 1143: FROM wip_operations wop1

1139: FROM wip_operations wop
1140: WHERE wop.wip_entity_id = p_jobID
1141: AND wop.operation_seq_num >
1142: (SELECT NVL(MAX(wop1.operation_seq_num),0)
1143: FROM wip_operations wop1
1144: WHERE wop1.wip_entity_id = p_jobID
1145: AND p_fm_op > p_to_op
1146: AND p_to_step = WIP_CONSTANTS.SCRAP
1147: AND p_to_op >= wop1.operation_seq_num