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.INV_KANBAN_PKG dependencies on INV_PROJECT

Line 42: SELECT inv_project.get_locsegs(locator_id, org_id)

38: BEGIN
39: IF locator_id IS NULL THEN
40: RETURN (NULL);
41: ELSE
42: SELECT inv_project.get_locsegs(locator_id, org_id)
43: INTO locator_name
44: FROM mtl_item_locations
45: WHERE inventory_location_id = locator_id
46: AND organization_id = org_id;

Line 382: * Use the function INV_PROJECT.Get_Locsegs() to get the

378: AND mkcv.inventory_item_id = msiv.inventory_item_id
379: AND mkcv.organization_id = msiv.organization_id;
380:
381: /* PJM-WMS Integration:
382: * Use the function INV_PROJECT.Get_Locsegs() to get the
383: * concatenated segments of the locators.
384: */
385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;

Line 385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);

381: /* PJM-WMS Integration:
382: * Use the function INV_PROJECT.Get_Locsegs() to get the
383: * concatenated segments of the locators.
384: */
385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;

Line 386: x_project := inv_project.get_project_number;

382: * Use the function INV_PROJECT.Get_Locsegs() to get the
383: * concatenated segments of the locators.
384: */
385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;

Line 387: x_task := inv_project.get_task_number;

383: * concatenated segments of the locators.
384: */
385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;
391: x_source_org_id := source_org_id;

Line 388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);

384: */
385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;
391: x_source_org_id := source_org_id;
392: /*End of PJM-WMS Integration */

Line 389: x_source_project := inv_project.get_project_number;

385: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;
391: x_source_org_id := source_org_id;
392: /*End of PJM-WMS Integration */
393: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);

Line 390: x_source_task := inv_project.get_task_number;

386: x_project := inv_project.get_project_number;
387: x_task := inv_project.get_task_number;
388: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;
391: x_source_org_id := source_org_id;
392: /*End of PJM-WMS Integration */
393: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);
394: x_message := 'Item: ' || x_item;

Line 516: , inv_project.get_project_number project_num

512: , msiv.description
513: , mkc.kanban_size
514: , mkc.subinventory_name
515: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
516: , inv_project.get_project_number project_num
517: , inv_project.get_task_number task_num
518: , mfg2.meaning card_status_name
519: , mfg3.meaning supply_status_name
520: , mfg4.meaning source_type

Line 517: , inv_project.get_task_number task_num

513: , mkc.kanban_size
514: , mkc.subinventory_name
515: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
516: , inv_project.get_project_number project_num
517: , inv_project.get_task_number task_num
518: , mfg2.meaning card_status_name
519: , mfg3.meaning supply_status_name
520: , mfg4.meaning source_type
521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)

Line 524: , inv_project.get_project_number src_project_num

520: , mfg4.meaning source_type
521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
522: , mkc.source_subinventory
523: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
524: , inv_project.get_project_number src_project_num
525: , inv_project.get_task_number src_task_num
526: , mka.last_update_date
527: , mfg5.meaning act_supp_status_name
528: , mfg6.meaning doc_type

Line 525: , inv_project.get_task_number src_task_num

521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
522: , mkc.source_subinventory
523: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
524: , inv_project.get_project_number src_project_num
525: , inv_project.get_task_number src_task_num
526: , mka.last_update_date
527: , mfg5.meaning act_supp_status_name
528: , mfg6.meaning doc_type
529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num

Line 533: , inv_project.get_project_number act_project_num

529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
531: , mka.source_subinventory act_sub
532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
533: , inv_project.get_project_number act_project_num
534: , inv_project.get_task_number act_task_num
535: , pv.vendor_name vendor
536: , pvsa.vendor_site_code vendor_site
537: , wl.line_code

Line 534: , inv_project.get_task_number act_task_num

530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
531: , mka.source_subinventory act_sub
532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
533: , inv_project.get_project_number act_project_num
534: , inv_project.get_task_number act_task_num
535: , pv.vendor_name vendor
536: , pvsa.vendor_site_code vendor_site
537: , wl.line_code
538: , pv_act.vendor_name vendor_last_activity