DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_OPERATION_RESOURCES

Line 5502: wip_operation_resources where wip_entity_id

5498: -- swai: bug 7017062 nvl the max(resource_seq_num)
5499: cursor get_next_resource_seq_num ( p_wip_entity_id NUMBER,
5500: p_operation_seq_num NUMBER ) IS
5501: select nvl(MAX(RESOURCE_SEQ_NUM),0)+ 10 from
5502: wip_operation_resources where wip_entity_id
5503: = p_wip_entity_id and operation_seq_num =
5504: p_operation_seq_num;
5505:
5506:

Line 8278: WIP_OPERATION_RESOURCES WOR,

8274: , WTD.attribute13
8275: , WTD.attribute14
8276: , WTD.attribute15
8277: FROM CSD_REPAIR_JOB_XREF CRJX,
8278: WIP_OPERATION_RESOURCES WOR,
8279: WIP_ENTITIES WE,
8280: CSD_WIP_TRANSACTION_DETAILS WTD,
8281: BOM_RESOURCES BR,
8282: wip_operations wo,

Line 8714: WIP_OPERATION_RESOURCES WOR,

8710: wor.basis_type basis_type,
8711: wtd.object_version_number,
8712: 'N' new_row
8713: FROM CSD_REPAIR_JOB_XREF CRJX,
8714: WIP_OPERATION_RESOURCES WOR,
8715: WIP_ENTITIES WE,
8716: CSD_WIP_TRANSACTION_DETAILS WTD,
8717: BOM_RESOURCES BR,
8718: wip_operations wo,