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 371: * Use the function INV_PROJECT.Get_Locsegs() to get the

367: AND mkcv.inventory_item_id = msiv.inventory_item_id
368: AND mkcv.organization_id = msiv.organization_id;
369:
370: /* PJM-WMS Integration:
371: * Use the function INV_PROJECT.Get_Locsegs() to get the
372: * concatenated segments of the locators.
373: */
374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;

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

370: /* PJM-WMS Integration:
371: * Use the function INV_PROJECT.Get_Locsegs() to get the
372: * concatenated segments of the locators.
373: */
374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;

Line 375: x_project := inv_project.get_project_number;

371: * Use the function INV_PROJECT.Get_Locsegs() to get the
372: * concatenated segments of the locators.
373: */
374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;

Line 376: x_task := inv_project.get_task_number;

372: * concatenated segments of the locators.
373: */
374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;
380: x_source_org_id := source_org_id;

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

373: */
374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;
380: x_source_org_id := source_org_id;
381: /*End of PJM-WMS Integration */

Line 378: x_source_project := inv_project.get_project_number;

374: x_locator := inv_project.get_locsegs(locator_id, p_org_id);
375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;
380: x_source_org_id := source_org_id;
381: /*End of PJM-WMS Integration */
382: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);

Line 379: x_source_task := inv_project.get_task_number;

375: x_project := inv_project.get_project_number;
376: x_task := inv_project.get_task_number;
377: x_source_locator := inv_project.get_locsegs(source_locator_id, source_org_id);
378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;
380: x_source_org_id := source_org_id;
381: /*End of PJM-WMS Integration */
382: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);
383: x_message := 'Item: ' || x_item;

Line 505: , inv_project.get_project_number project_num

501: , msiv.description
502: , mkc.kanban_size
503: , mkc.subinventory_name
504: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
505: , inv_project.get_project_number project_num
506: , inv_project.get_task_number task_num
507: , mfg2.meaning card_status_name
508: , mfg3.meaning supply_status_name
509: , mfg4.meaning source_type

Line 506: , inv_project.get_task_number task_num

502: , mkc.kanban_size
503: , mkc.subinventory_name
504: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
505: , inv_project.get_project_number project_num
506: , inv_project.get_task_number task_num
507: , mfg2.meaning card_status_name
508: , mfg3.meaning supply_status_name
509: , mfg4.meaning source_type
510: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)

Line 513: , inv_project.get_project_number src_project_num

509: , mfg4.meaning source_type
510: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
511: , mkc.source_subinventory
512: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
513: , inv_project.get_project_number src_project_num
514: , inv_project.get_task_number src_task_num
515: , mka.last_update_date
516: , mfg5.meaning act_supp_status_name
517: , mfg6.meaning doc_type

Line 514: , inv_project.get_task_number src_task_num

510: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
511: , mkc.source_subinventory
512: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
513: , inv_project.get_project_number src_project_num
514: , inv_project.get_task_number src_task_num
515: , mka.last_update_date
516: , mfg5.meaning act_supp_status_name
517: , mfg6.meaning doc_type
518: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num

Line 522: , inv_project.get_project_number act_project_num

518: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
519: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
520: , mka.source_subinventory act_sub
521: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
522: , inv_project.get_project_number act_project_num
523: , inv_project.get_task_number act_task_num
524: , pv.vendor_name vendor
525: , pvsa.vendor_site_code vendor_site
526: , wl.line_code

Line 523: , inv_project.get_task_number act_task_num

519: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
520: , mka.source_subinventory act_sub
521: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
522: , inv_project.get_project_number act_project_num
523: , inv_project.get_task_number act_task_num
524: , pv.vendor_name vendor
525: , pvsa.vendor_site_code vendor_site
526: , wl.line_code
527: , pv_act.vendor_name vendor_last_activity