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.

[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 90: DELETE FROM mtl_kanban_pull_sequences

86: DELETE FROM mrp_low_level_codes
87: WHERE plan_id = g_kanban_info_rec.kanban_plan_id
88: AND organization_id = g_kanban_info_rec.organization_id;
89:
90: DELETE FROM mtl_kanban_pull_sequences
91: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
92:
93: END IF;
94:

Line 686: mtl_kanban_pull_sequences ps

682: fnd_global.user_id,
683: sysdate,
684: fnd_global.user_id
685: FROM
686: mtl_kanban_pull_sequences ps
687: WHERE /* ps.wip_line_id = l_line_id
688: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
689: AND*/ ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
690: 2, G_PRODUCTION_KANBAN,

Line 744: mtl_kanban_pull_sequences ps

740: fnd_global.user_id,
741: sysdate,
742: fnd_global.user_id
743: FROM
744: mtl_kanban_pull_sequences ps
745: WHERE ps.wip_line_id = l_line_id
746: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
747: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
748: 2, G_PRODUCTION_KANBAN,

Line 2503: -- in the mtl_kanban_pull_sequences table

2499: END IF;
2500:
2501: -- the first insert here is for the item for which we have
2502: -- foreacast based on the allocation percentages mentioned
2503: -- in the mtl_kanban_pull_sequences table
2504:
2505: IF NOT item_schedule_entries%ISOPEN THEN
2506: OPEN item_schedule_entries;
2507: END IF;

Line 2605: mtl_kanban_pull_sequences ps

2601: fnd_global.user_id,
2602: sysdate,
2603: fnd_global.user_id
2604: FROM
2605: mtl_kanban_pull_sequences ps
2606: WHERE
2607: -- eKanban Changes.
2608: /* ps.wip_line_id = l_line_id
2609: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 2668: mtl_kanban_pull_sequences ps

2664: fnd_global.user_id,
2665: sysdate,
2666: fnd_global.user_id
2667: FROM
2668: mtl_kanban_pull_sequences ps
2669: WHERE
2670: ps.wip_line_id = l_line_id
2671: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
2672: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,

Line 2862: -- in the mtl_kanban_pull_sequences table

2858: END IF;
2859:
2860: -- the first insert here is for the item for which we have
2861: -- mds/mps based on the allocation percentages mentioned
2862: -- in the mtl_kanban_pull_sequences table
2863:
2864: l_item_id := p_inventory_item_id;
2865: IF NOT item_schedule_entries%ISOPEN THEN
2866: OPEN item_schedule_entries;

Line 2950: mtl_kanban_pull_sequences ps

2946: fnd_global.user_id,
2947: sysdate,
2948: fnd_global.user_id
2949: FROM
2950: mtl_kanban_pull_sequences ps
2951: WHERE
2952: -- eKanban Changes.
2953: /* ps.wip_line_id = l_line_id
2954: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 3013: mtl_kanban_pull_sequences ps

3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.user_id
3012: FROM
3013: mtl_kanban_pull_sequences ps
3014: WHERE
3015: ps.wip_line_id = l_line_id
3016: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
3017: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,

Line 3174: -- in the mtl_kanban_pull_sequences table

3170: END IF;
3171:
3172: -- the first insert here is for the item for which we have
3173: -- mds/mps based on the allocation percentages mentioned
3174: -- in the mtl_kanban_pull_sequences table
3175:
3176: l_item_id := p_inventory_item_id;
3177: IF NOT item_schedule_entries%ISOPEN THEN
3178: OPEN item_schedule_entries;

Line 3260: mtl_kanban_pull_sequences ps

3256: fnd_global.user_id,
3257: sysdate,
3258: fnd_global.user_id
3259: FROM
3260: mtl_kanban_pull_sequences ps
3261: WHERE
3262: -- eKanban Changes.
3263: /* ps.wip_line_id = l_line_id
3264: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 3324: mtl_kanban_pull_sequences ps

3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id
3323: FROM
3324: mtl_kanban_pull_sequences ps
3325: WHERE
3326: ps.wip_line_id = l_line_id
3327: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
3328: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,

Line 3902: -- and inserts the information into mtl_kanban_pull_sequences table

3898: END Kanban_Calculation_Pvt;
3899: -- ========================================================================
3900: -- this function calculates the kanban size/number for each
3901: -- kanban item/location that we need to plan in this plan run
3902: -- and inserts the information into mtl_kanban_pull_sequences table
3903: -- ========================================================================
3904:
3905: FUNCTION Calculate_Kanban_Quantity (p_total_workdays IN NUMBER)
3906: RETURN BOOLEAN IS

Line 3979: FROM mtl_kanban_pull_sequences

3975: attribute12,
3976: attribute13,
3977: attribute14,
3978: attribute15
3979: FROM mtl_kanban_pull_sequences
3980: WHERE kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
3981: 2, G_PRODUCTION_KANBAN,
3982: 1, g_kanban_info_rec.kanban_plan_id,
3983: G_PRODUCTION_KANBAN)

Line 4018: -- mtl_kanban_pull_sequences

4014:
4015: EXIT WHEN cur_kanban_demand%NOTFOUND;
4016:
4017: -- now get some information about this item/location from
4018: -- mtl_kanban_pull_sequences
4019:
4020: OPEN cur_pull_sequence;
4021:
4022: FETCH cur_pull_sequence

Line 4178: -- Now go ahead and insert/update into mtl_kanban_pull_sequences table

4174:
4175:
4176: END IF;
4177:
4178: -- Now go ahead and insert/update into mtl_kanban_pull_sequences table
4179: -- information about this kanban item/location for this kanban plan
4180:
4181: SELECT
4182: fnd_global.conc_request_id,