DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on WIP_SUB_OPERATION_RESOURCES

Line 1736: INSERT INTO WIP_SUB_OPERATION_RESOURCES

1732:
1733: l_stmt_num := 20;
1734:
1735: forall l_job_counter in indices of p_new_rj_we_id_tbl
1736: INSERT INTO WIP_SUB_OPERATION_RESOURCES
1737: (wip_entity_id,
1738: operation_seq_num,
1739: resource_seq_num,
1740: organization_id,

Line 1859: from wip_sub_operation_resources wsor

1855: wsor.substitute_group_num,
1856: wsor.replacement_group_num,
1857: wsor.principle_flag,
1858: wsor.setup_id
1859: from wip_sub_operation_resources wsor
1860: WHERE wsor.wip_entity_id = p_rep_we_id
1861: AND wsor.operation_seq_num <= p_curr_op_seq_num);
1862:
1863: l_stmt_num := 40;

Line 2803: INSERT INTO WIP_SUB_OPERATION_RESOURCES

2799: BEGIN
2800: l_stmt_num := 10;
2801:
2802: -- Related bugs : 3313454
2803: INSERT INTO WIP_SUB_OPERATION_RESOURCES
2804: (WIP_ENTITY_ID,
2805: OPERATION_SEQ_NUM,
2806: RESOURCE_SEQ_NUM,
2807: ORGANIZATION_ID,