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.PJM_TASK_AUTO_ASSIGN dependencies on STANDARD

Line 418: AND NVL(standard_operation_id,

414: SELECT task_id
415: FROM pjm_default_tasks
416: WHERE organization_id = C_org_id
417: AND project_id = C_proj_id
418: AND NVL(standard_operation_id,
419: nvl(C_operation_id,-1)) = nvl(C_operation_id,-1)
420: AND C_wip_entity like nvl(wip_entity_pattern , '%')
421: AND NVL(assembly_item_id,
422: nvl(C_assy_item_id,-1)) = nvl(C_assy_item_id,-1)

Line 427: 'STANDARD_OPERATION', standard_operation_id,

423: AND NVL(department_id, nvl(C_dept_id,-1)) = nvl(C_dept_id,-1)
424: AND assignment_type = 'RESOURCE'
425: ORDER BY decode(v_attributes(1),
426: 'DEPARTMENT', department_id,
427: 'STANDARD_OPERATION', standard_operation_id,
428: 'ASSEMBLY_ITEM', assembly_item_id,
429: 'WIP_ENTITY', sign(length(wip_entity_pattern))
430: ) ASC
431: , decode(v_attributes(2),

Line 433: 'STANDARD_OPERATION', standard_operation_id,

429: 'WIP_ENTITY', sign(length(wip_entity_pattern))
430: ) ASC
431: , decode(v_attributes(2),
432: 'DEPARTMENT', department_id,
433: 'STANDARD_OPERATION', standard_operation_id,
434: 'ASSEMBLY_ITEM', assembly_item_id,
435: 'WIP_ENTITY', sign(length(wip_entity_pattern))
436: ) ASC
437: , decode(v_attributes(3),

Line 439: 'STANDARD_OPERATION', standard_operation_id,

435: 'WIP_ENTITY', sign(length(wip_entity_pattern))
436: ) ASC
437: , decode(v_attributes(3),
438: 'DEPARTMENT', department_id,
439: 'STANDARD_OPERATION', standard_operation_id,
440: 'ASSEMBLY_ITEM', assembly_item_id,
441: 'WIP_ENTITY', sign(length(wip_entity_pattern))
442: ) ASC
443: , decode(v_attributes(4),

Line 445: 'STANDARD_OPERATION', standard_operation_id,

441: 'WIP_ENTITY', sign(length(wip_entity_pattern))
442: ) ASC
443: , decode(v_attributes(4),
444: 'DEPARTMENT', department_id,
445: 'STANDARD_OPERATION', standard_operation_id,
446: 'ASSEMBLY_ITEM', assembly_item_id,
447: 'WIP_ENTITY', sign(length(wip_entity_pattern))
448: ) ASC
449: , instr(wip_entity_pattern||'*%','%') DESC

Line 561: AND NVL(standard_operation_id, nvl(C_operation_id,-1)) =

557: nvl(C_wip_matl_txn_type,'ANY')
558: AND C_wip_entity like nvl(wip_entity_pattern , '%')
559: AND NVL(assembly_item_id, nvl(C_assy_item_id,-1)) =
560: nvl(C_assy_item_id,-1)
561: AND NVL(standard_operation_id, nvl(C_operation_id,-1)) =
562: nvl(C_operation_id,-1)
563: AND NVL(department_id, nvl(C_dept_id,-1)) = nvl(C_dept_id,-1)
564: AND assignment_type = 'WIPMAT'
565: ORDER BY decode(v_attributes(1),

Line 570: 'STANDARD_OPERATION', standard_operation_id,

566: 'ITEM_NUMBER', to_char(inventory_item_id),
567: 'CATEGORY', to_char(category_id),
568: 'SUBINVENTORY', subinventory_code,
569: 'DEPARTMENT', department_id,
570: 'STANDARD_OPERATION', standard_operation_id,
571: 'ASSEMBLY_ITEM', assembly_item_id,
572: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
573: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
574: ) ASC

Line 580: 'STANDARD_OPERATION', standard_operation_id,

576: 'ITEM_NUMBER', to_char(inventory_item_id),
577: 'CATEGORY', to_char(category_id),
578: 'SUBINVENTORY', subinventory_code,
579: 'DEPARTMENT', department_id,
580: 'STANDARD_OPERATION', standard_operation_id,
581: 'ASSEMBLY_ITEM', assembly_item_id,
582: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
583: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
584: ) ASC

Line 590: 'STANDARD_OPERATION', standard_operation_id,

586: 'ITEM_NUMBER', to_char(inventory_item_id),
587: 'CATEGORY', to_char(category_id),
588: 'SUBINVENTORY', subinventory_code,
589: 'DEPARTMENT', department_id,
590: 'STANDARD_OPERATION', standard_operation_id,
591: 'ASSEMBLY_ITEM', assembly_item_id,
592: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
593: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
594: ) ASC

Line 600: 'STANDARD_OPERATION', standard_operation_id,

596: 'ITEM_NUMBER', to_char(inventory_item_id),
597: 'CATEGORY', to_char(category_id),
598: 'SUBINVENTORY', subinventory_code,
599: 'DEPARTMENT', department_id,
600: 'STANDARD_OPERATION', standard_operation_id,
601: 'ASSEMBLY_ITEM', assembly_item_id,
602: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
603: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
604: ) ASC

Line 610: 'STANDARD_OPERATION', standard_operation_id,

606: 'ITEM_NUMBER', to_char(inventory_item_id),
607: 'CATEGORY', to_char(category_id),
608: 'SUBINVENTORY', subinventory_code,
609: 'DEPARTMENT', department_id,
610: 'STANDARD_OPERATION', standard_operation_id,
611: 'ASSEMBLY_ITEM', assembly_item_id,
612: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
613: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
614: ) ASC

Line 620: 'STANDARD_OPERATION', standard_operation_id,

616: 'ITEM_NUMBER', to_char(inventory_item_id),
617: 'CATEGORY', to_char(category_id),
618: 'SUBINVENTORY', subinventory_code,
619: 'DEPARTMENT', department_id,
620: 'STANDARD_OPERATION', standard_operation_id,
621: 'ASSEMBLY_ITEM', assembly_item_id,
622: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
623: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
624: ) ASC

Line 630: 'STANDARD_OPERATION', standard_operation_id,

626: 'ITEM_NUMBER', to_char(inventory_item_id),
627: 'CATEGORY', to_char(category_id),
628: 'SUBINVENTORY', subinventory_code,
629: 'DEPARTMENT', department_id,
630: 'STANDARD_OPERATION', standard_operation_id,
631: 'ASSEMBLY_ITEM', assembly_item_id,
632: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
633: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
634: ) ASC

Line 640: 'STANDARD_OPERATION', standard_operation_id,

636: 'ITEM_NUMBER', to_char(inventory_item_id),
637: 'CATEGORY', to_char(category_id),
638: 'SUBINVENTORY', subinventory_code,
639: 'DEPARTMENT', department_id,
640: 'STANDARD_OPERATION', standard_operation_id,
641: 'ASSEMBLY_ITEM', assembly_item_id,
642: 'WIP_ENTITY', sign(length(wip_entity_pattern)),
643: 'WIP_MATL_TXN_TYPE', wip_matl_txn_type
644: ) ASC

Line 865: , o.standard_operation_id

861: 5, t.transaction_source_id,
862: null)
863: , e.primary_item_id
864: , t.department_id
865: , o.standard_operation_id
866: FROM mtl_material_transactions t
867: , wip_entities e
868: , wip_operations o
869: WHERE transaction_id = C_transaction_id

Line 1201: SELECT o.standard_operation_id

1197:
1198: -- for discrete job
1199: CURSOR d1 ( C_organization_id NUMBER, C_wip_entity_id NUMBER, C_operation_seq_num NUMBER )
1200: IS
1201: SELECT o.standard_operation_id
1202: FROM wip_entities e
1203: , wip_operations o
1204: WHERE e.organization_id = C_organization_id
1205: AND e.wip_entity_id = C_wip_entity_id

Line 1213: SELECT s.standard_operation_id

1209:
1210: -- for flow schedule
1211: CURSOR f1 ( C_organization_id NUMBER, C_wip_entity_id NUMBER, C_operation_seq_num NUMBER, C_primary_item_id NUMBER )
1212: IS
1213: SELECT s.standard_operation_id
1214: FROM wip_flow_schedules f
1215: , bom_operational_routings r
1216: , bom_operation_sequences s
1217: WHERE f.wip_entity_id = C_wip_entity_id