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.INVKBCGN dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 269: MTL_KANBAN_PULL_SEQUENCES

265: supplier_site_id, source_organization_id, source_subinventory,
266: source_locator_id, wip_line_id, kanban_size, number_of_cards,
267: release_kanban_flag
268: from
269: MTL_KANBAN_PULL_SEQUENCES
270: where
271: kanban_plan_id = -1 AND
272: source_type in (1,2,3,4) AND
273: --release_kanban_flag = 1 AND

Line 355: MTL_KANBAN_PULL_SEQUENCES

351: supplier_site_id, source_organization_id, source_subinventory,
352: source_locator_id, wip_line_id, kanban_size, number_of_cards,
353: release_kanban_flag
354: from
355: MTL_KANBAN_PULL_SEQUENCES
356: where
357: pull_sequence_id = X_pull_seq_id AND
358: source_type in (1,2,3,4) AND
359: --release_kanban_flag = 1 AND

Line 489: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||

485: 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||
486: ' mkps.subinventory_name , mkps.locator_id , mkps.source_type , mkps.supplier_id,' ||
487: ' mkps.supplier_site_id, mkps.source_organization_id, mkps.source_subinventory,' ||
488: ' mkps.source_locator_id, mkps.wip_line_id, mkps.kanban_size, mkps.number_of_cards, ' ||
489: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||
490: ' WHERE '||
491: ' mkps.organization_id = :org_id AND mkps.source_type in (1,2,3,4) AND ' ||
492: ' nvl(mkps.subinventory_name,''9999'') = ' ||
493: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||

Line 535: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||

531: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
532: ' subinventory_name , locator_id , source_type , supplier_id,' ||
533: ' supplier_site_id, source_organization_id, source_subinventory,' ||
534: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
535: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||
536: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
537: ' nvl(subinventory_name,''9999'') = ' ||
538: ' nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
539: ' nvl(source_type,-9999) = nvl(:source_type,nvl(source_type,-9999)) AND '||

Line 678: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||

674: d_sql_stmt := 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||
675: ' mkps.subinventory_name , mkps.locator_id , mkps.source_type , mkps.supplier_id,' ||
676: ' mkps.supplier_site_id, mkps.source_organization_id, mkps.source_subinventory,' ||
677: ' mkps.source_locator_id, mkps.wip_line_id, mkps.kanban_size, mkps.number_of_cards, ' ||
678: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||
679: ' WHERE '||
680: ' mkps.organization_id = :org_id AND mkps.source_type in (1,2,3,4) AND ' ||
681: ' nvl(mkps.subinventory_name,''9999'') = ' ||
682: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||

Line 728: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||

724: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
725: ' subinventory_name , locator_id , source_type , supplier_id,' ||
726: ' supplier_site_id, source_organization_id, source_subinventory,' ||
727: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
728: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||
729: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
730: 'nvl(subinventory_name,''9999'') = ' ||
731: 'nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
732: 'nvl(source_type,-9999) = nvl(:source_type, nvl(source_type,-9999)) AND '||

Line 915: MTL_KANBAN_PULL_SEQUENCES

911: supplier_site_id, source_organization_id, source_subinventory,
912: source_locator_id, wip_line_id, kanban_size, number_of_cards ,
913: release_kanban_flag
914: from
915: MTL_KANBAN_PULL_SEQUENCES
916: where
917: organization_id = X_org_id AND
918: nvl(subinventory_name,'9999') =
919: nvl(X_subinv, nvl(subinventory_name,'9999')) AND

Line 945: MTL_KANBAN_PULL_SEQUENCES mkps

941: mkps.supplier_site_id, mkps.source_organization_id, mkps.source_subinventory,
942: mkps.source_locator_id, mkps.wip_line_id, mkps.kanban_size, mkps.number_of_cards ,
943: mkps.release_kanban_flag
944: from
945: MTL_KANBAN_PULL_SEQUENCES mkps
946: where mkps.organization_id = X_org_id AND
947: nvl(mkps.subinventory_name,'9999') = nvl(X_subinv, nvl(mkps.subinventory_name,'9999')) AND
948: nvl(mkps.source_type,-9999) = nvl(X_source_type, nvl(mkps.source_type,-9999)) AND
949: ( X_supplier_id is null or (X_supplier_id is not null and

Line 1077: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||

1073: d_sql_stmt := 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||
1074: ' mkps.subinventory_name , mkps.locator_id , mkps.source_type , mkps.supplier_id,' ||
1075: ' mkps.supplier_site_id, mkps.source_organization_id, mkps.source_subinventory,' ||
1076: ' mkps.source_locator_id, mkps.wip_line_id, mkps.kanban_size, mkps.number_of_cards, ' ||
1077: ' mkps.release_kanban_flag from mtl_kanban_pull_sequences mkps '||
1078: ' WHERE '||
1079: ' mkps.organization_id = :org_id AND mkps.source_type in (1,2,3,4) AND ' ||
1080: ' nvl(mkps.subinventory_name,''9999'') = ' ||
1081: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||

Line 1121: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||

1117: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
1118: ' subinventory_name , locator_id , source_type , supplier_id,' ||
1119: ' supplier_site_id, source_organization_id, source_subinventory,' ||
1120: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
1121: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||
1122: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
1123: ' nvl(subinventory_name,''9999'') = ' ||
1124: ' nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
1125: ' nvl(source_type,-9999) = nvl(:source_type,nvl(source_type,-9999)) AND '||

Line 1347: -- Step1: Logic is Find the planning_effectivity for pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES

1343: PUT_LINE('FLM_EKB_OPS_FLAG - '||NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0));
1344:
1345: If NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN
1346: PUT_LINE('X_pull_sequence_id- '||X_pull_sequence_id);
1347: -- Step1: Logic is Find the planning_effectivity for pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES
1348: SELECT number_of_cards
1349: , kanban_size
1350: , future_no_of_cards
1351: , future_card_size

Line 1358: FROM mtl_kanban_pull_sequences mkps

1354: , l_kanban_size
1355: , l_future_no_of_cards
1356: , l_future_card_size
1357: , l_planning_effectivity
1358: FROM mtl_kanban_pull_sequences mkps
1359: WHERE pull_sequence_id = X_pull_sequence_id;
1360:
1361: PUT_LINE('l_number_of_cards - '||l_number_of_cards);
1362: PUT_LINE('kanban_size - '||l_kanban_size);

Line 1372: UPDATE mtl_kanban_pull_sequences SET

1368: IF ( l_future_no_of_cards IS NOT NULL or l_future_card_size IS NOT NULL ) THEN
1369:
1370: PUT_LINE('planning_effectivity is less than SYSDATE');
1371:
1372: UPDATE mtl_kanban_pull_sequences SET
1373: number_of_cards=nvl(l_future_no_of_cards,number_of_cards)
1374: ,kanban_size=nvl(l_future_card_size,kanban_size)
1375: ,future_no_of_cards=null
1376: ,future_card_size=null

Line 2039: mtl_kanban_pull_sequences pull

2035: subinventory_name,locator_id,pull.organization_id
2036: into x_item_name,x_org_code,x_subinventory,l_locator_id,
2037: l_organization_id
2038: from mtl_system_items_kfv a , mtl_parameters b,
2039: mtl_kanban_pull_sequences pull
2040: where a.inventory_item_id = pull.inventory_item_id
2041: and a.organization_id = Pull.organization_id
2042: and b.organization_id = Pull.organization_id
2043: and pull.pull_sequence_id = p_Pull_sequence_id;

Line 2092: from mtl_kanban_pull_sequences where pull_sequence_id = p_Pull_sequence_id;

2088: --make a call to Create_Kanban_Cards
2089:
2090: select nvl(planning_effectivity,trunc(sysdate)),future_card_size,kanban_size,number_of_cards,future_no_of_cards
2091: into l_plan_eff_date,l_future_size,l_size,l_num_card,l_future_num_card
2092: from mtl_kanban_pull_sequences where pull_sequence_id = p_Pull_sequence_id;
2093:
2094: if ( (l_plan_eff_date <= trunc(sysdate) and nvl(l_future_size,nvl(l_size,0)) = 0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_size,0)=0) ) then
2095: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');