[Home] [Help]
6065: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
6066: bom_calendar_dates bcd3,
6067: fnd_user fu,
6068: bom_departments bd,
6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,
6073: wip_parameters wp /*ER 4276433*/
6275: bom_calendar_dates bcd2,
6276: fnd_user fu,
6277: mtl_system_items msi,
6278: mtl_parameters mp,
6279: hr_organization_information hoi,
6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6489: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6490: bom_calendar_dates bcd3,
6491: fnd_user fu,
6492: bom_departments bd,
6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,
6497: wip_parameters wp /*ER 4276433*/
6717: fnd_user fu,
6718: mtl_item_revisions mir,
6719: mtl_system_items msi,
6720: mtl_parameters mp,
6721: hr_organization_information hoi,
6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6996: -- because Req Import need this information.
6997: -- get the OU, set context for MOAC. Need to set it for each PO Move
6998: -- record found.
6999: select to_number(ORG_INFORMATION3) into l_ou_id
7000: from HR_ORGANIZATION_INFORMATION
7001: where ORGANIZATION_ID = l_org_id
7002: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
7003: FND_REQUEST.SET_ORG_ID (l_ou_id);
7004:
7053: l_launch_req_import = WIP_CONSTANTS.YES) THEN
7054:
7055: -- get the OU, set context for MOAC
7056: select to_number(ORG_INFORMATION3) into l_ou_id
7057: from HR_ORGANIZATION_INFORMATION
7058: where ORGANIZATION_ID = l_org_id
7059: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
7060: FND_REQUEST.SET_ORG_ID (l_ou_id);
7061: