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 243: MTL_KANBAN_PULL_SEQUENCES

239: supplier_site_id, source_organization_id, source_subinventory,
240: source_locator_id, wip_line_id, kanban_size, number_of_cards,
241: release_kanban_flag
242: from
243: MTL_KANBAN_PULL_SEQUENCES
244: where
245: kanban_plan_id = -1 AND
246: source_type in (1,2,3,4) AND
247: --release_kanban_flag = 1 AND

Line 323: MTL_KANBAN_PULL_SEQUENCES

319: supplier_site_id, source_organization_id, source_subinventory,
320: source_locator_id, wip_line_id, kanban_size, number_of_cards,
321: release_kanban_flag
322: from
323: MTL_KANBAN_PULL_SEQUENCES
324: where
325: pull_sequence_id = X_pull_seq_id AND
326: source_type in (1,2,3,4) AND
327: --release_kanban_flag = 1 AND

Line 451: ' release_kanban_flag, from MTL_KANBAN_PULL_SEQUENCES where '||

447: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
448: ' subinventory_name , locator_id , source_type , supplier_id,' ||
449: ' supplier_site_id, source_organization_id, source_subinventory,' ||
450: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
451: ' release_kanban_flag, from MTL_KANBAN_PULL_SEQUENCES where '||
452: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
453: ' nvl(subinventory_name,''9999'') = ' ||
454: ' nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
455: ' nvl(source_type,-9999) = nvl(:source_type,nvl(source_type,-9999)) AND '||

Line 591: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||

587: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
588: ' subinventory_name , locator_id , source_type , supplier_id,' ||
589: ' supplier_site_id, source_organization_id, source_subinventory,' ||
590: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
591: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||
592: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
593: 'nvl(subinventory_name,''9999'') = ' ||
594: 'nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
595: 'nvl(source_type,-9999) = nvl(:source_type, nvl(source_type,-9999)) AND '||

Line 770: MTL_KANBAN_PULL_SEQUENCES

766: supplier_site_id, source_organization_id, source_subinventory,
767: source_locator_id, wip_line_id, kanban_size, number_of_cards ,
768: release_kanban_flag
769: from
770: MTL_KANBAN_PULL_SEQUENCES
771: where
772: organization_id = X_org_id AND
773: nvl(subinventory_name,'9999') =
774: nvl(X_subinv, nvl(subinventory_name,'9999')) AND

Line 866: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||

862: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
863: ' subinventory_name , locator_id , source_type , supplier_id,' ||
864: ' supplier_site_id, source_organization_id, source_subinventory,' ||
865: ' source_locator_id, wip_line_id, kanban_size, number_of_cards, ' ||
866: ' release_kanban_flag from MTL_KANBAN_PULL_SEQUENCES where '||
867: ' organization_id = :org_id AND source_type in (1,2,3,4) AND ' ||
868: ' nvl(subinventory_name,''9999'') = ' ||
869: ' nvl(:subinv, nvl(subinventory_name,''9999'')) AND ' ||
870: ' nvl(source_type,-9999) = nvl(:source_type,nvl(source_type,-9999)) AND '||