DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on BOM_CALENDAR_DATES

Line 5696: * IF the purchase item lead time falls outside of BOM_CALENDAR_DATES

5692: * This procedure is equivalent to witpspr_po_req in wiltps4.ppc
5693: * This procedure is used to insert purchase order requisition into
5694: * PO_REQUISITIONS_INTERFACE_ALL
5695: * NOTES:
5696: * IF the purchase item lead time falls outside of BOM_CALENDAR_DATES
5697: * THEN no PO req will be created
5698: ****************************************************************************/
5699: PROCEDURE insert_po_req(p_gib IN group_rec_t,
5700: x_returnStatus OUT NOCOPY VARCHAR2) IS

Line 5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required

5925: wip_operation_resources wor,
5926: bom_resources br,
5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
5932: bom_calendar_dates bcd3,
5933: fnd_user fu,

Line 5930: bom_calendar_dates bcd4,

5926: bom_resources br,
5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
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,

Line 5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required

5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
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,

Line 5932: bom_calendar_dates bcd3,

5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
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,

Line 6133: bom_calendar_dates bcd1,

6129: NULL, -- group_code
6130: msi.buyer_id -- suggested_buyer_id
6131: FROM bom_resources br,
6132: bom_departments bd,
6133: bom_calendar_dates bcd1,
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,
6137: mtl_parameters mp,

Line 6134: bom_calendar_dates bcd2,

6130: msi.buyer_id -- suggested_buyer_id
6131: FROM bom_resources br,
6132: bom_departments bd,
6133: bom_calendar_dates bcd1,
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,
6137: mtl_parameters mp,
6138: hr_organization_information hoi,

Line 6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required

6335: wip_operation_resources wor,
6336: bom_resources br,
6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6342: bom_calendar_dates bcd3,
6343: fnd_user fu,

Line 6340: bom_calendar_dates bcd4,

6336: bom_resources br,
6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6342: bom_calendar_dates bcd3,
6343: fnd_user fu,
6344: bom_departments bd,

Line 6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required

6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
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,

Line 6342: bom_calendar_dates bcd3,

6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
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,

Line 6560: bom_calendar_dates bcd1,

6556: NULL, -- group_code
6557: MAX(msi.buyer_id) -- suggested_buyer_id
6558: FROM bom_departments bd,
6559: bom_resources br,
6560: bom_calendar_dates bcd1,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,

Line 6561: bom_calendar_dates bcd2,

6557: MAX(msi.buyer_id) -- suggested_buyer_id
6558: FROM bom_departments bd,
6559: bom_resources br,
6560: bom_calendar_dates bcd1,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,