DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on BOM_RESOURCES

Line 1081: FROM BOM_RESOURCES BR,

1077: BSSOR.schedule_seq_num , --NULL, --schedule_seq_num, / -- Bug 7371846
1078: BSSOR.substitute_group_num,
1079: BSSOR.replacement_group_num, --replacement_group_num,
1080: NULL --setup_id
1081: FROM BOM_RESOURCES BR,
1082: BOM_STD_SUB_OP_RESOURCES BSSOR,
1083: WIP_OPERATIONS wo
1084: WHERE WO.WIP_ENTITY_ID = x_wip_entity_id
1085: AND WO.OPERATION_SEQ_NUM = x_to_op

Line 1331: FROM BOM_RESOURCES RSC,

1327: ORS.SCHEDULE_SEQ_NUM, --bugfix 2493065
1328: ORS.SUBSTITUTE_GROUP_NUM,
1329: ORS.PRINCIPLE_FLAG,
1330: ORS.SETUP_ID
1331: FROM BOM_RESOURCES RSC,
1332: BOM_OPERATION_RESOURCES ORS,
1333: WIP_OPERATIONS OPS
1334: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
1335: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id

Line 1386: FROM BOM_RESOURCES RSC,

1382: ORS.ATTRIBUTE15,
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