APPS.WIP_OPERATIONS_UTILITIES dependencies on BOM_RESOURCES

Line 391: BOM_RESOURCES R

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;
395:

Line 509: FROM BOM_RESOURCES BR,

505: BSSOR.schedule_seq_num ,
506: BSSOR.substitute_group_num,
507: BSSOR.replacement_group_num,
508: NULL --setup_id
509: FROM BOM_RESOURCES BR,
510: BOM_STD_SUB_OP_RESOURCES BSSOR
511: where bssor.standard_operation_id=X_Standard_Operation_Id
512: and BSSOR.RESOURCE_ID = BR.RESOURCE_ID;
513:

Line 529: BOM_RESOURCES R

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
533: AND NVL(R.DISABLE_DATE, SYSDATE + 1) > SYSDATE;