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.FLM_KANBAN_PLANNING_UTIL dependencies on INV_KANBAN_PVT

Line 1854: if l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then

1850: attribute15=l_attr_15
1851: where pull_sequence_id = l_prod_pull_seq_id
1852: returning source_type into l_source_type;
1853:
1854: if l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1855: FLM_MULTIPLE_SUPPLIERS.multiple_supplier_kanban_cards --Bug#14230963
1856: (p_pull_seq_id => l_prod_pull_seq_id,
1857: x_retcode => l_ret_status,
1858: x_err_msg => l_err_msg);

Line 1869: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

1865: from mtl_kanban_cards
1866: where pull_sequence_id = l_prod_pull_seq_id
1867: and max_replenishments is null
1868: and disable_date is null
1869: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1870: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);
1871:
1872: l_card_count := 0;
1873: if l_curr_card_count < l_calculate_card_count then

Line 1870: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);

1866: where pull_sequence_id = l_prod_pull_seq_id
1867: and max_replenishments is null
1868: and disable_date is null
1869: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1870: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);
1871:
1872: l_card_count := 0;
1873: if l_curr_card_count < l_calculate_card_count then
1874:

Line 1892: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;

1888: r_kanban_card_rec.inventory_item_id := l_item_id;
1889: r_kanban_card_rec.organization_code := null;
1890: r_kanban_card_rec.organization_id := l_org_id;
1891: r_kanban_card_rec.subinventory_name := l_subinv;
1892: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
1893: if l_eff_date is null then
1894: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
1895: else
1896: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;

Line 1894: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;

1890: r_kanban_card_rec.organization_id := l_org_id;
1891: r_kanban_card_rec.subinventory_name := l_subinv;
1892: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
1893: if l_eff_date is null then
1894: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
1895: else
1896: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
1897: end if;
1898: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;

Line 1896: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;

1892: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
1893: if l_eff_date is null then
1894: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
1895: else
1896: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
1897: end if;
1898: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;
1899: r_kanban_card_rec.source_type := l_src_type;
1900: r_kanban_card_rec.kanban_size := l_kanban_size;

Line 1898: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;

1894: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
1895: else
1896: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
1897: end if;
1898: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;
1899: r_kanban_card_rec.source_type := l_src_type;
1900: r_kanban_card_rec.kanban_size := l_kanban_size;
1901: r_kanban_card_rec.locator_id := l_locator;
1902: r_kanban_card_rec.supplier_id := null;

Line 1978: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

1974: from mtl_kanban_cards
1975: where pull_sequence_id = l_prod_pull_seq_id
1976: and max_replenishments is null
1977: and disable_date is null
1978: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1979: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);
1980:
1981: l_upd_card_count := 0;
1982: --l_calculate_card_count := l_calculate_card_count-l_card_count;

Line 1979: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);

1975: where pull_sequence_id = l_prod_pull_seq_id
1976: and max_replenishments is null
1977: and disable_date is null
1978: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1979: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);
1980:
1981: l_upd_card_count := 0;
1982: --l_calculate_card_count := l_calculate_card_count-l_card_count;
1983: while (l_upd_card_count < (l_calculate_card_count - l_curr_card_count))

Line 1997: , INV_Kanban_PVT.G_Card_Status_Active

1993: , inventory_item_id
1994: , organization_id
1995: , subinventory_name
1996: , supply_status
1997: , INV_Kanban_PVT.G_Card_Status_Active
1998: , INV_Kanban_Pvt.g_card_type_replenishable
1999: , source_type
2000: , kanban_size
2001: , creation_date

Line 1998: , INV_Kanban_Pvt.g_card_type_replenishable

1994: , organization_id
1995: , subinventory_name
1996: , supply_status
1997: , INV_Kanban_PVT.G_Card_Status_Active
1998: , INV_Kanban_Pvt.g_card_type_replenishable
1999: , source_type
2000: , kanban_size
2001: , creation_date
2002: , created_by

Line 2078: and card_status = INV_Kanban_PVT.G_Card_Status_Planned

2074: , l_kanban_card_rec.disable_date
2075: , l_kanban_card_rec.replacement_flag
2076: from mtl_kanban_cards
2077: where pull_sequence_id = l_prod_pull_seq_id
2078: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2079: and max_replenishments is null
2080: and disable_date is null
2081: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2082: and rownum = 1;

Line 2081: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

2077: where pull_sequence_id = l_prod_pull_seq_id
2078: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2079: and max_replenishments is null
2080: and disable_date is null
2081: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2082: and rownum = 1;
2083:
2084: if l_card_count <= nvl(l_no_of_temp_cards,0) then
2085: l_kanban_card_rec.max_replenishments := l_no_of_cycles;

Line 2317: if l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then

2313: where pull_sequence_id = l_prod_pull_seq_id
2314: returning source_type into l_source_type;
2315:
2316:
2317: if l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
2318: FLM_MULTIPLE_SUPPLIERS.multiple_supplier_kanban_cards
2319: (p_pull_seq_id => l_prod_pull_seq_id,
2320: x_retcode => l_ret_status,
2321: x_err_msg => l_err_msg);

Line 2332: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

2328: from mtl_kanban_cards
2329: where pull_sequence_id = l_prod_pull_seq_id
2330: and max_replenishments is null
2331: and disable_date is null
2332: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2333: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);
2334:
2335: l_card_count := 0;
2336: if l_curr_card_count < l_calculate_card_count then

Line 2333: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);

2329: where pull_sequence_id = l_prod_pull_seq_id
2330: and max_replenishments is null
2331: and disable_date is null
2332: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2333: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned);
2334:
2335: l_card_count := 0;
2336: if l_curr_card_count < l_calculate_card_count then
2337:

Line 2354: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;

2350: r_kanban_card_rec.inventory_item_id := l_item_id;
2351: r_kanban_card_rec.organization_code := null;
2352: r_kanban_card_rec.organization_id := l_org_id;
2353: r_kanban_card_rec.subinventory_name := l_subinv;
2354: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
2355: if l_eff_date is null then
2356: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
2357: else
2358: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;

Line 2356: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;

2352: r_kanban_card_rec.organization_id := l_org_id;
2353: r_kanban_card_rec.subinventory_name := l_subinv;
2354: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
2355: if l_eff_date is null then
2356: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
2357: else
2358: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
2359: end if;
2360: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;

Line 2358: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;

2354: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
2355: if l_eff_date is null then
2356: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
2357: else
2358: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
2359: end if;
2360: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;
2361: r_kanban_card_rec.source_type := l_src_type;
2362: r_kanban_card_rec.kanban_size := l_kanban_size;

Line 2360: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;

2356: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
2357: else
2358: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Planned;
2359: end if;
2360: r_kanban_card_rec.kanban_card_type := INV_Kanban_Pvt.g_card_type_replenishable;
2361: r_kanban_card_rec.source_type := l_src_type;
2362: r_kanban_card_rec.kanban_size := l_kanban_size;
2363: r_kanban_card_rec.locator_id := l_locator;
2364: r_kanban_card_rec.supplier_id := null;

Line 2439: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

2435: from mtl_kanban_cards
2436: where pull_sequence_id = l_prod_pull_seq_id
2437: and max_replenishments is null
2438: and disable_date is null
2439: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2440: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);
2441: l_upd_card_count := 0;
2442: --l_calculate_card_count := l_calculate_card_count - l_card_count;
2443: while (l_upd_card_count < (l_calculate_card_count - l_curr_card_count))

Line 2440: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);

2436: where pull_sequence_id = l_prod_pull_seq_id
2437: and max_replenishments is null
2438: and disable_date is null
2439: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2440: and card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold);
2441: l_upd_card_count := 0;
2442: --l_calculate_card_count := l_calculate_card_count - l_card_count;
2443: while (l_upd_card_count < (l_calculate_card_count - l_curr_card_count))
2444: loop

Line 2457: , INV_Kanban_PVT.G_Card_Status_Active

2453: , inventory_item_id
2454: , organization_id
2455: , subinventory_name
2456: , supply_status
2457: , INV_Kanban_PVT.G_Card_Status_Active
2458: , INV_Kanban_Pvt.g_card_type_replenishable
2459: , source_type
2460: , kanban_size
2461: , creation_date

Line 2458: , INV_Kanban_Pvt.g_card_type_replenishable

2454: , organization_id
2455: , subinventory_name
2456: , supply_status
2457: , INV_Kanban_PVT.G_Card_Status_Active
2458: , INV_Kanban_Pvt.g_card_type_replenishable
2459: , source_type
2460: , kanban_size
2461: , creation_date
2462: , created_by

Line 2538: and card_status = INV_Kanban_PVT.G_Card_Status_Planned

2534: , l_kanban_card_rec.disable_date
2535: , l_kanban_card_rec.replacement_flag
2536: from mtl_kanban_cards
2537: where pull_sequence_id = l_prod_pull_seq_id
2538: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2539: and max_replenishments is null
2540: and disable_date is null
2541: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2542: and rownum = 1;

Line 2541: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

2537: where pull_sequence_id = l_prod_pull_seq_id
2538: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2539: and max_replenishments is null
2540: and disable_date is null
2541: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2542: and rownum = 1;
2543: if l_card_count <= nvl(l_no_of_temp_cards,0) then
2544: l_kanban_card_rec.max_replenishments := l_no_of_cycles;
2545: l_kanban_card_rec.disable_date := l_temp_exp_date;