APPS.WIP_OPERATIONS_UTILITIES dependencies on BOM_STD_OP_RESOURCES

Line 390: FROM BOM_STD_OP_RESOURCES S,

386: S.ATTRIBUTE7, S.ATTRIBUTE8, S.ATTRIBUTE9,
387: S.ATTRIBUTE10, S.ATTRIBUTE11, S.ATTRIBUTE12,
388: S.ATTRIBUTE13, S.ATTRIBUTE14, S.ATTRIBUTE15,
389: S.SUBSTITUTE_GROUP_NUM, S.SCHEDULE_SEQ_NUM,S.PRINCIPLE_FLAG,0 --/* Added : -- bug 7371859
390: FROM BOM_STD_OP_RESOURCES S,
391: BOM_RESOURCES R
392: WHERE S.STANDARD_OPERATION_ID = X_Standard_Operation_Id
393: AND R.RESOURCE_ID = S.RESOURCE_ID
394: AND NVL(R.DISABLE_DATE, SYSDATE + 1) > SYSDATE;

Line 528: FROM BOM_STD_OP_RESOURCES S,

524: P_Num_Resources NUMBER;
525: BEGIN
526: SELECT COUNT(R.RESOURCE_ID)
527: INTO P_Num_Resources
528: FROM BOM_STD_OP_RESOURCES S,
529: BOM_RESOURCES R
530: WHERE S.STANDARD_OPERATION_ID = X_Standard_Operation_Id
531: AND R.ORGANIZATION_ID = X_Organization_Id
532: AND R.RESOURCE_ID = S.RESOURCE_ID