eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_KANBAN_SNAPSHOT_PK

Line 110: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN

106: -- only to detect loops and not for planning purposes.
107: -- We gather demand by looking at the input to the plan
108: -- and then blow it down to the component item/locations
109:
110: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
111: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
112: MRP_UTIL.MRP_LOG (g_log_message);
113: raise exc_error_condition;
114: END IF;

Line 884: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

880: WHERE mp.organization_id = g_kanban_info_rec.organization_id
881: AND bor.line_id (+) = p_line_id
882: AND bor.assembly_item_id (+) = p_assembly_item_id
883: AND bor.organization_id (+) = mp.organization_id
884: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
885: bor.assembly_item_id,
886: bor.organization_id,
887: bor.line_id,
888: bor.alternate_routing_designator)

Line 890: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

886: bor.organization_id,
887: bor.line_id,
888: bor.alternate_routing_designator)
889: /* BUG: 1668867 Double kanban demand */
890: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
891: p_assembly_item_id,
892: bic.component_item_id,
893: mp.organization_id)
894: AND bbom.assembly_item_id = p_assembly_item_id

Line 974: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

970: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
971: AND msi.inventory_item_id = mllc.component_item_id
972: AND msi.organization_id = mllc.organization_id
973: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
974: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
975: mllc.assembly_item_id,
976: mllc.organization_id,
977: null,
978: mllc.alternate_designator)

Line 981: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

977: null,
978: mllc.alternate_designator)
979: /* End of Update */
980: /* BUG 1668867, Double Kanban demand problem */
981: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
982: p_assembly_item_id,
983: mllc.component_item_id,
984: mllc.organization_id)
985: AND ((nvl(msi.ato_forecast_control, G_NO_FCST_CONTROL) = G_NO_FCST_CONTROL)

Line 1440: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1436: bbom.assembly_item_id = p_assembly_item_id
1437: AND bbom.organization_id = g_kanban_info_rec.organization_id
1438: AND nvl(bbom.alternate_bom_designator, 'NONE') = nvl(p_top_alt, 'NONE')
1439: /* Bug 2279877, not pick up discrete jobs w/o line_id
1440: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1441: bor.assembly_item_id,
1442: bor.organization_id,
1443: bor.line_id,
1444: bor.alternate_routing_designator)

Line 1447: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1443: bor.line_id,
1444: bor.alternate_routing_designator)
1445: */
1446: /* BUG: 1668867 , Fix for double demand */
1447: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1448: p_assembly_item_id,
1449: bic.component_item_id,
1450: g_kanban_info_rec.organization_id)
1451: AND bic.bill_sequence_id = bbom.common_bill_sequence_id

Line 1527: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1523: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
1524: AND msi.inventory_item_id = mllc.component_item_id
1525: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
1526: /* Bug 2279877, not pick up discrete jobs w/o line_id
1527: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1528: mllc.assembly_item_id,
1529: mllc.organization_id,
1530: null,
1531: mllc.alternate_designator)

Line 1535: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1531: mllc.alternate_designator)
1532: */
1533: /* End of Update */
1534: /* Bug 1668867 : Double Kanban demand */
1535: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1536: p_assembly_item_id,
1537: mllc.component_item_id,
1538: mllc.organization_id)
1539: AND msi.organization_id = mllc.organization_id

Line 1926: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1922: WHERE mp.organization_id = g_kanban_info_rec.organization_id
1923: AND bor.line_id (+) = p_line_id
1924: AND bor.assembly_item_id (+) = p_assembly_item_id
1925: AND bor.organization_id (+) = mp.organization_id
1926: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1927: bor.assembly_item_id,
1928: bor.organization_id,
1929: bor.line_id,
1930: bor.alternate_routing_designator)

Line 1940: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1936: AND nvl(bic.disable_date, g_kanban_info_rec.bom_effectivity + 1)
1937: >= g_kanban_info_rec.bom_effectivity
1938: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
1939: /* BUG: 1821216 Double kanban demand */
1940: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1941: p_assembly_item_id,
1942: bic.component_item_id,
1943: mp.organization_id)
1944: AND NOT EXISTS (

Line 2014: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

2010: AND ((mllc.to_subinventory = p_subinventory
2011: AND nvl(mllc.to_locator_id,-1) = nvl(p_locator_id,-1)) OR
2012: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
2013: /* Bug 1668867 : Double Kanban demand */
2014: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
2015: p_assembly_item_id,
2016: mllc.component_item_id,
2017: mllc.organization_id)
2018: AND msi.inventory_item_id = mllc.component_item_id

Line 2021: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

2017: mllc.organization_id)
2018: AND msi.inventory_item_id = mllc.component_item_id
2019: AND msi.organization_id = mllc.organization_id
2020: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
2021: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
2022: mllc.assembly_item_id,
2023: mllc.organization_id,
2024: null,
2025: mllc.alternate_designator)

Line 3911: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN

3907: -- only to detect loops and not for planning purposes.
3908: -- We gather demand by looking at the input to the plan
3909: -- and then blow it down to the component item/locations
3910:
3911: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
3912: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
3913: MRP_UTIL.MRP_LOG (g_log_message);
3914: raise exc_error_condition;
3915: END IF;