1034: i_prog_appl_id,
1035: i_prog_id,
1036: SYSDATE
1037: FROM
1038: BOM_RESOURCES BR,
1039: WIP_OPERATION_RESOURCES WOR
1040: WHERE
1041: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
1042: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
1779: prior_completion_quantity)),
1780: 0)
1781: FROM
1782: wip_operation_resources w2,
1783: bom_resources BR,
1784: cst_comp_snapshot cocd
1785: WHERE
1786: w2.wip_entity_id = w1.wip_entity_id AND
1787: w2.organization_id = w1.organization_id AND
1957: i_prog_appl_id,
1958: i_prog_id,
1959: SYSDATE
1960: FROM
1961: BOM_RESOURCES BR,
1962: WIP_OPERATION_RESOURCES WOR
1963: WHERE
1964: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
1965: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND