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 112: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN

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

Line 947: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

943: WHERE mp.organization_id = g_kanban_info_rec.organization_id
944: AND bor.line_id (+) = p_line_id
945: AND bor.assembly_item_id (+) = p_assembly_item_id
946: AND bor.organization_id (+) = mp.organization_id
947: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
948: bor.assembly_item_id,
949: bor.organization_id,
950: bor.line_id,
951: bor.alternate_routing_designator)

Line 953: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

949: bor.organization_id,
950: bor.line_id,
951: bor.alternate_routing_designator)
952: /* BUG: 1668867 Double kanban demand */
953: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
954: p_assembly_item_id,
955: bic.component_item_id,
956: mp.organization_id)
957: AND bbom.assembly_item_id = p_assembly_item_id

Line 1037: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1033: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
1034: AND msi.inventory_item_id = mllc.component_item_id
1035: AND msi.organization_id = mllc.organization_id
1036: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
1037: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1038: mllc.assembly_item_id,
1039: mllc.organization_id,
1040: null,
1041: mllc.alternate_designator)

Line 1044: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1040: null,
1041: mllc.alternate_designator)
1042: /* End of Update */
1043: /* BUG 1668867, Double Kanban demand problem */
1044: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1045: p_assembly_item_id,
1046: mllc.component_item_id,
1047: mllc.organization_id)
1048: AND ((nvl(msi.ato_forecast_control, G_NO_FCST_CONTROL) = G_NO_FCST_CONTROL)

Line 1519: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1515: bbom.assembly_item_id = p_assembly_item_id
1516: AND bbom.organization_id = g_kanban_info_rec.organization_id
1517: AND nvl(bbom.alternate_bom_designator, 'NONE') = nvl(p_top_alt, 'NONE')
1518: /* Bug 2279877, not pick up discrete jobs w/o line_id
1519: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1520: bor.assembly_item_id,
1521: bor.organization_id,
1522: bor.line_id,
1523: bor.alternate_routing_designator)

Line 1526: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1522: bor.line_id,
1523: bor.alternate_routing_designator)
1524: */
1525: /* BUG: 1668867 , Fix for double demand */
1526: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1527: p_assembly_item_id,
1528: bic.component_item_id,
1529: g_kanban_info_rec.organization_id)
1530: AND bic.bill_sequence_id = bbom.common_bill_sequence_id

Line 1606: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

1602: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
1603: AND msi.inventory_item_id = mllc.component_item_id
1604: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
1605: /* Bug 2279877, not pick up discrete jobs w/o line_id
1606: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
1607: mllc.assembly_item_id,
1608: mllc.organization_id,
1609: null,
1610: mllc.alternate_designator)

Line 1614: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

1610: mllc.alternate_designator)
1611: */
1612: /* End of Update */
1613: /* Bug 1668867 : Double Kanban demand */
1614: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
1615: p_assembly_item_id,
1616: mllc.component_item_id,
1617: mllc.organization_id)
1618: AND msi.organization_id = mllc.organization_id

Line 2021: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

2017: WHERE mp.organization_id = g_kanban_info_rec.organization_id
2018: AND bor.line_id (+) = p_line_id
2019: AND bor.assembly_item_id (+) = p_assembly_item_id
2020: AND bor.organization_id (+) = mp.organization_id
2021: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
2022: bor.assembly_item_id,
2023: bor.organization_id,
2024: bor.line_id,
2025: bor.alternate_routing_designator)

Line 2035: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

2031: AND nvl(bic.disable_date, g_kanban_info_rec.bom_effectivity + 1)
2032: >= g_kanban_info_rec.bom_effectivity
2033: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
2034: /* BUG: 1821216 Double kanban demand */
2035: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
2036: p_assembly_item_id,
2037: bic.component_item_id,
2038: mp.organization_id)
2039: AND NOT EXISTS (

Line 2109: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (

2105: AND ((mllc.to_subinventory = p_subinventory
2106: AND nvl(mllc.to_locator_id,-1) = nvl(p_locator_id,-1)) OR
2107: (mllc.to_subinventory is NULL and p_bill_or_ps = 1) )
2108: /* Bug 1668867 : Double Kanban demand */
2109: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_assy_cfgitem (
2110: p_assembly_item_id,
2111: mllc.component_item_id,
2112: mllc.organization_id)
2113: AND msi.inventory_item_id = mllc.component_item_id

Line 2116: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (

2112: mllc.organization_id)
2113: AND msi.inventory_item_id = mllc.component_item_id
2114: AND msi.organization_id = mllc.organization_id
2115: /* Updated by Liye Ma 4/30/2001 for bug 1757798 and 1745046*/
2116: AND 1 = MRP_KANBAN_SNAPSHOT_PK.Check_Min_Priority (
2117: mllc.assembly_item_id,
2118: mllc.organization_id,
2119: null,
2120: mllc.alternate_designator)

Line 4405: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN

4401: -- only to detect loops and not for planning purposes.
4402: -- We gather demand by looking at the input to the plan
4403: -- and then blow it down to the component item/locations
4404:
4405: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
4406: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
4407: MRP_UTIL.MRP_LOG (g_log_message);
4408: raise exc_error_condition;
4409: END IF;