DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on BOM_STD_OP_RESOURCES

Line 20: | using bom_std_op_resources |

16: | 09/29/00 GRATNAM Modified update_job_name()for |
17: | assy returns |
18: | 01/15/01 SBHASKAR Bugfix 1523334:Incase of Jump, insert |
19: | into wip_operation_resources |
20: | using bom_std_op_resources |
21: +============================================================================*/
22:
23: g_update_flag boolean:=TRUE;
24: --mes

Line 1343: -- We will fetch the details from BOM_STD_OP_RESOURCES

1339: AND RSC.ORGANIZATION_ID = OPS.ORGANIZATION_ID;
1340:
1341: -- Begin bugfix 1523334 : If the above INSERT fails, it could be because OPS.OPERATION_SEQUENCE_ID
1342: -- is null. This will be true in case of JUMP operation.
1343: -- We will fetch the details from BOM_STD_OP_RESOURCES
1344:
1345: IF (sql%rowcount = 0) THEN
1346: l_stat_num := 15;
1347: INSERT INTO WIP_OPERATION_RESOURCES

Line 1387: BOM_STD_OP_RESOURCES ORS,

1383: ORS.SCHEDULE_SEQ_NUM,ORS.PRINCIPLE_FLAG, --Added : -- bug 7371846
1384: ORS.SUBSTITUTE_GROUP_NUM, --Added : -- bug 7371846
1385: 0 --Added : -- make it as zero on resources level -- bug 7371846
1386: FROM BOM_RESOURCES RSC,
1387: BOM_STD_OP_RESOURCES ORS,
1388: WIP_OPERATIONS OPS
1389: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
1390: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id
1391: AND OPS.OPERATION_SEQ_NUM = X_op_seq_num