APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_STANDARD_OPERATIONS

Line 1709: from bom_standard_operations

1705: l_stmt_num := 130;
1706: -- get the standard op code in this case ....
1707: select operation_code
1708: into p_starting_job_rec.operation_code
1709: from bom_standard_operations
1710: where STANDARD_OPERATION_ID = p_starting_job_rec.standard_operation_id;
1711:
1712: end if;
1713:

Line 6795: l_operation_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%type;

6791: l_op_rptd_time number;
6792: l_err_code number;
6793: l_err_msg varchar2(2000);
6794:
6795: l_operation_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%type;
6796: l_op_rptd_times number;
6797:
6798: -- logging variables
6799: l_stmt_num number:=0;

Line 6900: FROM bom_standard_operations BSO,

6896: l_operation_code,
6897: p_new_op_seq_id,
6898: p_new_std_op_id,
6899: p_new_dept_id
6900: FROM bom_standard_operations BSO,
6901: bom_operation_sequences BOS,
6902: bom_departments BD
6903: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
6904: AND BSO.standard_operation_id = BOS.standard_operation_id

Line 7048: FROM bom_standard_operations BSO,

7044: p_new_op_seq_code,
7045: p_new_op_seq_id,
7046: p_new_std_op_id,
7047: p_new_dept_id
7048: FROM bom_standard_operations BSO,
7049: bom_operation_sequences BOS,
7050: bom_departments BD
7051: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7052: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)

Line 7084: FROM bom_standard_operations BSO,

7080: p_new_op_seq_code,
7081: p_new_op_seq_id,
7082: p_new_std_op_id,
7083: p_new_dept_id
7084: FROM bom_standard_operations BSO,
7085: bom_operation_sequences BOS,
7086: bom_departments BD
7087: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7088: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)

Line 7922: bom_standard_operations BSO

7918: into p_start_op_seq_num,
7919: p_start_op_seq_id,
7920: p_start_op_seq_code
7921: from bom_operation_sequences BOS,
7922: bom_standard_operations BSO
7923: where bos.OPERATION_SEQUENCE_ID = l_start_op_seq_id
7924: and BOS.routing_sequence_id = p_rtg_seq_id
7925: and BSO.standard_operation_id (+) = BOS.standard_operation_id
7926: and p_revision_date between BOS.effectivity_date and nvl(BOS.disable_date, p_revision_date+1);

Line 7949: bom_standard_operations BSO

7945: BEGIN
7946: select 1
7947: into l_flag
7948: from bom_operation_sequences BOS,
7949: bom_standard_operations BSO
7950: where bos.OPERATION_SEQ_NUM = nvl(p_start_op_seq_num,bos.OPERATION_SEQ_NUM)
7951: and bos.OPERATION_SEQUENCE_ID = nvl(p_start_op_seq_id,bos.OPERATION_SEQUENCE_ID)
7952: -- ST : Fix for bug 5116062 : Added an outer NVL clause
7953: and nvl(bso.OPERATION_CODE,'$$&&') = nvl(nvl(p_start_op_seq_code,bso.OPERATION_CODE),'$$&&')