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.M4R_7B1_WSM_IN dependencies on DUAL

Line 835: FROM DUAL;

831: END IF;
832:
833: SELECT M4R_7B1_OSFM_S1.NEXTVAL
834: INTO l_event_key
835: FROM DUAL;
836:
837: g_exception_tracking_msg := 'Raising oracle.apps.cln.ch.collaboration.update event ';
838:
839: wf_event.raise(p_event_name => 'oracle.apps.cln.ch.collaboration.update',

Line 1136: FROM DUAL;

1132: END IF;
1133:
1134: SELECT wsm_lot_move_txn_interface_s.NEXTVAL
1135: INTO l_header_id
1136: FROM DUAL;
1137:
1138: SELECT wip_interface_s.NEXTVAL
1139: INTO l_txn_id
1140: FROM DUAL;

Line 1140: FROM DUAL;

1136: FROM DUAL;
1137:
1138: SELECT wip_interface_s.NEXTVAL
1139: INTO l_txn_id
1140: FROM DUAL;
1141:
1142: SELECT wip_interface_s.NEXTVAL
1143: INTO l_group_id
1144: FROM DUAL;

Line 1144: FROM DUAL;

1140: FROM DUAL;
1141:
1142: SELECT wip_interface_s.NEXTVAL
1143: INTO l_group_id
1144: FROM DUAL;
1145:
1146: IF (g_debug_level <= 1) THEN
1147: cln_debug_pub.Add('l_header_id : ' || l_header_id, 1);
1148: cln_debug_pub.Add('l_txn_id : ' || l_txn_id, 1);

Line 1653: FROM DUAL;

1649: END IF;
1650:
1651: SELECT wsm_lot_sm_ifc_header_s.NEXTVAL
1652: INTO l_header_id
1653: FROM DUAL;
1654:
1655: SELECT wsm_lot_job_interface_s.NEXTVAL
1656: INTO l_group_id
1657: FROM DUAL;

Line 1657: FROM DUAL;

1653: FROM DUAL;
1654:
1655: SELECT wsm_lot_job_interface_s.NEXTVAL
1656: INTO l_group_id
1657: FROM DUAL;
1658:
1659: IF ((p_hdr_rec.first_unit_start_date IS NOT NULL ) AND (p_hdr_rec.scheduled_completion_date IS NOT NULL ))THEN
1660: -- Bug 4727381, Issue e : Condition changed from 'OR' to AND'
1661: l_sch_method := 3;

Line 1727: FROM DUAL;

1723: AND ((ALTERNATE_ROUTING_DESIGNATOR = p_hdr_rec.alt_routing_designator) OR (ALTERNATE_ROUTING_DESIGNATOR IS NULL));
1724:
1725: SELECT wsm_split_merge_transactions_s.NEXTVAL
1726: INTO l_trx_id
1727: FROM DUAL;
1728:
1729: SELECT wsm_split_merge_transactions_s.NEXTVAL
1730: INTO l_source_line_id
1731: FROM DUAL;

Line 1731: FROM DUAL;

1727: FROM DUAL;
1728:
1729: SELECT wsm_split_merge_transactions_s.NEXTVAL
1730: INTO l_source_line_id
1731: FROM DUAL;
1732:
1733: IF (g_debug_level <= 1) THEN
1734: cln_debug_pub.Add('l_comp_sub_inventory : '|| l_comp_sub_inventory,1);
1735: cln_debug_pub.Add('l_comp_locator_id : '|| l_comp_locator_id,1);

Line 2061: FROM DUAL;

2057: END IF;
2058:
2059: SELECT wsm_sm_txn_int_group_s.NEXTVAL
2060: INTO l_group_id
2061: FROM DUAL;
2062:
2063: SELECT wsm_sm_txn_interface_s.NEXTVAL
2064: INTO l_header_id
2065: FROM DUAL;

Line 2065: FROM DUAL;

2061: FROM DUAL;
2062:
2063: SELECT wsm_sm_txn_interface_s.NEXTVAL
2064: INTO l_header_id
2065: FROM DUAL;
2066:
2067: SELECT wsm_split_merge_transactions_s.NEXTVAL
2068: INTO l_trx_id
2069: FROM DUAL;

Line 2069: FROM DUAL;

2065: FROM DUAL;
2066:
2067: SELECT wsm_split_merge_transactions_s.NEXTVAL
2068: INTO l_trx_id
2069: FROM DUAL;
2070:
2071: SAVEPOINT before_insert;
2072:
2073: IF (g_debug_level <= 1) THEN

Line 3231: FROM DUAL;

3227: SAVEPOINT before_insert;
3228:
3229: SELECT mtl_material_transactions_s.NEXTVAL
3230: INTO l_trx_if_id
3231: FROM DUAL;
3232:
3233: SELECT mtl_material_transactions_s.NEXTVAL
3234: INTO l_trx_hdr_id
3235: FROM DUAL;

Line 3235: FROM DUAL;

3231: FROM DUAL;
3232:
3233: SELECT mtl_material_transactions_s.NEXTVAL
3234: INTO l_trx_hdr_id
3235: FROM DUAL;
3236:
3237: IF (g_debug_level <= 1) THEN
3238: cln_debug_pub.Add('l_trx_if_id : ' || l_trx_if_id, 1);
3239: cln_debug_pub.Add('l_trx_hdr_id : ' || l_trx_hdr_id, 1);

Line 3339: FROM DUAL;

3335: ELSE
3336:
3337: SELECT mtl_material_transactions_s.NEXTVAL
3338: INTO l_trx_if_id
3339: FROM DUAL;
3340:
3341: l_trx_bat_seq := l_trx_bat_seq +1;
3342:
3343: IF (g_debug_level <= 1) THEN

Line 3504: FROM DUAL;

3500: l_lot_qty := - l_rec.prev_lot_qty;
3501:
3502: SELECT mtl_material_transactions_s.NEXTVAL
3503: INTO l_trx_if_id
3504: FROM DUAL;
3505:
3506: IF (g_debug_level <= 1) THEN
3507: cln_debug_pub.Add('l_trx_if_id : ' || l_trx_if_id, 1);
3508: cln_debug_pub.Add('l_trx_bat_seq : ' || l_trx_bat_seq, 1);

Line 3706: FROM DUAL;

3702: l_err_msg);
3703:
3704: SELECT mtl_material_transactions_s.NEXTVAL
3705: INTO l_trx_if_id
3706: FROM DUAL;
3707:
3708: INSERT_INV_REC( p_process_type,
3709: p_org_id,
3710: p_user_id,

Line 4640: FROM DUAL;

4636: END IF;
4637:
4638: SELECT M4R_7B1_OSFM_S1.NEXTVAL
4639: INTO l_event_key
4640: FROM DUAL;
4641:
4642: g_exception_tracking_msg := 'Raising oracle.apps.cln.ch.collaboration.update event ';
4643:
4644: wf_event.raise(p_event_name => 'oracle.apps.cln.ch.collaboration.update',