[Home] [Help]
5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
5932: bom_calendar_dates bcd3,
5933: fnd_user fu,
5934: bom_departments bd,
5935: hr_organization_information hoi,
5936: wip_discrete_jobs wdj,
5937: wip_operations wo1,
5938: wip_operations wo2
5939: WHERE wmti.group_id = p_gib.group_id
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,
6137: mtl_parameters mp,
6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6342: bom_calendar_dates bcd3,
6343: fnd_user fu,
6344: bom_departments bd,
6345: hr_organization_information hoi,
6346: wip_discrete_jobs wdj,
6347: wip_operations wo1,
6348: wip_operations wo2
6349: WHERE wmti.group_id = p_gib.group_id
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6835: -- because Req Import need this information.
6836: -- get the OU, set context for MOAC. Need to set it for each PO Move
6837: -- record found.
6838: select to_number(ORG_INFORMATION3) into l_ou_id
6839: from HR_ORGANIZATION_INFORMATION
6840: where ORGANIZATION_ID = l_org_id
6841: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
6842: FND_REQUEST.SET_ORG_ID (l_ou_id);
6843:
6872: l_launch_req_import = WIP_CONSTANTS.YES) THEN
6873:
6874: -- get the OU, set context for MOAC
6875: select to_number(ORG_INFORMATION3) into l_ou_id
6876: from HR_ORGANIZATION_INFORMATION
6877: where ORGANIZATION_ID = l_org_id
6878: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
6879: FND_REQUEST.SET_ORG_ID (l_ou_id);
6880: