APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_OPERATIONS

Line 112: from wip_operations

108: bom_department_resources bdr,
109: bom_resources br
110: where br.organization_id = p_organization_id
111: and bdr.department_id = (select department_id
112: from wip_operations
113: where organization_id = p_organization_id
114: and wip_entity_id =p_wip_entity_id
115: and operation_seq_num = p_operation_seq_num )
116: and br.resource_id = bdr.resource_id

Line 819: from wip_operations wo, bom_departments bd

815: -- Get Department Id and Department Code
816:
817: select bd.department_id,bd.department_code
818: into l_department_id, l_department_code
819: from wip_operations wo, bom_departments bd
820: where wo.wip_entity_id = l_wip_entity_id and wo.organization_id = l_organization_id
821: and wo.operation_seq_num = l_operation_seq_num and wo.department_id = bd.department_id(+);
822:
823: l_stmt_num := 140;

Line 858: from wip_operations

854: bom_department_resources bdr,
855: bom_resources br
856: where br.organization_id = l_organization_id
857: and bdr.department_id = (select department_id
858: from wip_operations
859: where organization_id = l_organization_id
860: and wip_entity_id = l_wip_entity_id
861: and operation_seq_num = l_operation_seq_num)
862: and br.resource_id = bdr.resource_id

Line 1605: po_line_locations_all plla, wip_operations wo

1601: l_need_by_date,
1602: l_order_type_lookup_code
1603:
1604: from rcv_transactions rct, po_lines_all pla, po_line_types plt,
1605: po_line_locations_all plla, wip_operations wo
1606: where pla.po_header_id (+) = rct.po_header_id
1607: and pla.po_line_id (+) = rct.po_line_id
1608: and rct.po_line_location_id = plla.line_location_id (+)
1609: and pla.line_type_id = plt.line_type_id (+)