APPS.WIP_SF_STATUS dependencies on WIP_PARAMETERS

Line 183: from wip_parameters wp

179: l_osp_shop_floor_status VARCHAR2(10);
180:
181: cursor get_status (c_org_id number) is
182: select osp_shop_floor_status
183: from wip_parameters wp
184: where wp.organization_id = c_org_id;
185: BEGIN
186: OPEN get_status (p_org_id);
187: FETCH get_status into l_osp_shop_floor_status;

Line 309: from wip_parameters wp

305: begin
306:
307: select nvl(wp.osp_shop_floor_status,'@@@')
308: into l_osp_sf_status
309: from wip_parameters wp
310: where wp.organization_id = p_org_id;
311:
312: Select count(*)
313: into l_num_rcv_txn

Line 327: WIP_PARAMETERS WP,

323: SELECT COUNT(1)
324: INTO x_no_move_count
325: FROM WIP_OPERATIONS WOP,
326: WIP_OPERATION_RESOURCES WOR,
327: WIP_PARAMETERS WP,
328: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
329: WIP_SHOP_FLOOR_STATUSES WSFS
330: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
331: 2,/* Run */

Line 503: WIP_PARAMETERS WP,

499: SELECT WSFS.SHOP_FLOOR_STATUS_CODE
500: INTO x_sf_status
501: FROM WIP_OPERATIONS WOP,
502: WIP_OPERATION_RESOURCES WOR,
503: WIP_PARAMETERS WP,
504: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
505: WIP_SHOP_FLOOR_STATUSES WSFS
506: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
507: 2,/* Run */