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_ENTITIES

Line 137: g_exception_tracking_msg := 'Getting l_wip_entity_name from WIP_ENTITIES';

133: cln_debug_pub.Add('p_hdr_id : ' || p_hdr_id, 2);
134: cln_debug_pub.Add('p_alt_rout : ' || p_alt_rout, 2);
135: END IF;
136:
137: g_exception_tracking_msg := 'Getting l_wip_entity_name from WIP_ENTITIES';
138:
139: SELECT WIP_ENTITY_ID
140: INTO x_wip_entity_id
141: FROM WIP_ENTITIES

Line 141: FROM WIP_ENTITIES

137: g_exception_tracking_msg := 'Getting l_wip_entity_name from WIP_ENTITIES';
138:
139: SELECT WIP_ENTITY_ID
140: INTO x_wip_entity_id
141: FROM WIP_ENTITIES
142: WHERE WIP_ENTITY_NAME = p_job_name
143: AND ORGANIZATION_ID = p_org_id;
144:
145: IF (g_debug_level <= 1) THEN

Line 752: g_exception_tracking_msg := 'Querying WIP_ENTITIES for x_prev_wip_entity_id';

748: cln_debug_pub.Add('p_lot_code : ' || p_lot_code, 2);
749: cln_debug_pub.Add('p_alt_rout : ' || p_alt_rout, 2);
750: END IF;
751:
752: g_exception_tracking_msg := 'Querying WIP_ENTITIES for x_prev_wip_entity_id';
753:
754: SELECT wip_entity_id
755: INTO x_prev_wip_entity_id
756: FROM WIP_ENTITIES

Line 756: FROM WIP_ENTITIES

752: g_exception_tracking_msg := 'Querying WIP_ENTITIES for x_prev_wip_entity_id';
753:
754: SELECT wip_entity_id
755: INTO x_prev_wip_entity_id
756: FROM WIP_ENTITIES
757: WHERE wip_entity_name = p_lot_number
758: AND ORGANIZATION_ID = p_org_id;
759:
760: IF (g_debug_level <= 1) THEN

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 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 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: