DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on WIP_DISCRETE_JOBS

Line 104: FROM wip_operation_yields woy, wip_discrete_jobs wdj

100: MIN(woy.operation_seq_num) starting_op_seq,
101: WDJ.EST_SCRAP_ACCOUNT est_scrap_account,
102: WDJ.EST_SCRAP_VAR_ACCOUNT est_scrap_var_account,
103: WDJ.PRIMARY_ITEM_ID primary_item_id
104: FROM wip_operation_yields woy, wip_discrete_jobs wdj
105: WHERE woy.status IN (1, 3)
106: AND woy.wip_entity_id = DECODE(NVL(i_entity_id, 0), 0, woy.wip_entity_id, i_entity_id)
107: AND woy.organization_id = DECODE(NVL(i_organization_id, 0), 0, woy.organization_id, i_organization_id)
108: AND WDJ.WIP_ENTITY_ID = WOY.WIP_ENTITY_ID

Line 1162: WIP_DISCRETE_JOBS wdj,

1158: wdj.est_scrap_account,
1159: wdj.est_scrap_var_account,
1160: wdj.primary_item_id
1161: FROM WIP_COST_TXN_INTERFACE wcti,
1162: WIP_DISCRETE_JOBS wdj,
1163: WIP_ENTITIES we
1164: WHERE wcti.group_id = i_group_id
1165: AND we.entity_type = 5
1166: and we.wip_entity_id = wcti.wip_entity_id

Line 1606: wip_discrete_jobs wdj

1602: p_organization_id Number) IS
1603: SELECT wo.operation_seq_num,
1604: wdj.start_quantity
1605: FROM wip_operations wo,
1606: wip_discrete_jobs wdj
1607: WHERE wo.wip_entity_id = p_wip_entity_id
1608: AND wo.operation_seq_num <= p_op_seq_num
1609: AND wo.organization_id = p_organization_id
1610: AND wo.wip_entity_id = wdj.wip_entity_id