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 WIP_DISCRETE_JOBS

Line 149: g_exception_tracking_msg := 'Getting Job details from WIP_DISCRETE_JOBS';

145: IF (g_debug_level <= 1) THEN
146: cln_debug_pub.Add('x_wip_entity_id : '|| x_wip_entity_id,1);
147: END IF;
148:
149: g_exception_tracking_msg := 'Getting Job details from WIP_DISCRETE_JOBS';
150:
151: SELECT PRIMARY_ITEM_ID,WIP_ENTITY_ID,COMMON_BOM_SEQUENCE_ID,COMMON_ROUTING_SEQUENCE_ID,
152: BOM_REVISION,ROUTING_REVISION,BOM_REVISION_DATE,ALTERNATE_BOM_DESIGNATOR,
153: ALTERNATE_ROUTING_DESIGNATOR,COMPLETION_SUBINVENTORY,COMPLETION_LOCATOR_ID,ROUTING_REVISION_DATE

Line 157: FROM WIP_DISCRETE_JOBS

153: ALTERNATE_ROUTING_DESIGNATOR,COMPLETION_SUBINVENTORY,COMPLETION_LOCATOR_ID,ROUTING_REVISION_DATE
154: INTO x_inventory_item_id,x_wip_entity_id,x_common_bom_seq_id, x_common_rout_seq_id,
155: x_bom_rev,x_rout_rev,x_bom_rev_date,x_alt_bom,x_alt_rout,x_comp_sub_inventory,
156: x_comp_locator_id,x_rout_rev_date
157: FROM WIP_DISCRETE_JOBS
158: WHERE wip_entity_id = x_wip_entity_id;
159:
160: x_return_code :='S';
161:

Line 2239: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for l_prev_lot_number';

2235: END LOOP;
2236:
2237: ELSIF p_process_type = 'WIP_SPLIT' THEN
2238:
2239: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for l_prev_lot_number';
2240:
2241: BEGIN
2242:
2243: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY

Line 2245: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE

2241: BEGIN
2242:
2243: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY
2244: INTO l_prev_wip_entity_id,l_net_qty
2245: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE
2246: WHERE we.wip_entity_name = p_hdr_rec.prev_lot_number
2247: AND we.ORGANIZATION_ID = p_org_id
2248: AND we.wip_entity_id = wd.wip_entity_id;
2249:

Line 2456: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for prev_lot_number';

2452: BEGIN
2453:
2454: IF p_hdr_rec.transaction_type = 'CHANGE JOB NAME' THEN
2455:
2456: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for prev_lot_number';
2457:
2458: l_job_name := p_hdr_rec.prev_lot_number;
2459:
2460: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY

Line 2463: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE

2459:
2460: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY
2461: --INTO l_prev_wip_entity_id,l_net_qty bsaratna
2462: INTO l_wip_entity_id,l_net_qty
2463: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE
2464: WHERE we.wip_entity_name = p_hdr_rec.prev_lot_number
2465: AND we.ORGANIZATION_ID = p_org_id
2466: AND we.wip_entity_id = wd.wip_entity_id;
2467:

Line 2470: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for lot_number';

2466: AND we.wip_entity_id = wd.wip_entity_id;
2467:
2468: ELSE
2469:
2470: g_exception_tracking_msg := 'Querying WIP_DISCRETE_JOBS for lot_number';
2471:
2472: l_job_name:=p_hdr_rec.lot_number;
2473:
2474: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY

Line 2477: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE

2473:
2474: SELECT WE.WIP_ENTITY_ID,WD.NET_QUANTITY
2475: --INTO l_prev_wip_entity_id,l_net_qty bsaratna
2476: INTO l_wip_entity_id,l_net_qty
2477: FROM WIP_DISCRETE_JOBS WD,WIP_ENTITIES WE
2478: WHERE we.wip_entity_name = p_hdr_rec.lot_number
2479: AND we.ORGANIZATION_ID = p_org_id
2480: AND we.wip_entity_id = wd.wip_entity_id;
2481: