APPS.PJM_TASK_AUTOASSIGN_COPY dependencies on STANDARD

Line 29: AND standard_operation_id is null

25: AND category_id is null
26: AND po_header_id is null
27: AND subinventory_code is null
28: AND procure_flag is null
29: AND standard_operation_id is null
30: AND assembly_item_id is null
31: AND department_id is null
32: AND wip_entity_pattern is null
33: AND wip_matl_txn_type is null

Line 95: , standard_operation_id

91: , category_id
92: , po_header_id
93: , subinventory_code
94: , procure_flag
95: , standard_operation_id
96: , assembly_item_id
97: , department_id
98: , wip_entity_pattern
99: , wip_matl_txn_type

Line 141: AND standard_operation_id is null

137: AND category_id is null
138: AND po_header_id is null
139: AND subinventory_code is null
140: AND procure_flag is null
141: AND standard_operation_id is null
142: AND assembly_item_id is null
143: AND department_id is null
144: AND wip_entity_pattern is null
145: AND wip_matl_txn_type is null

Line 165: , standard_operation_id

161: , category_id
162: , po_header_id
163: , subinventory_code
164: , procure_flag
165: , standard_operation_id
166: , assembly_item_id
167: , department_id
168: , wip_entity_pattern
169: , wip_matl_txn_type

Line 211: AND standard_operation_id is null

207: AND category_id is null
208: AND po_header_id is null
209: AND subinventory_code is null
210: AND procure_flag is null
211: AND standard_operation_id is null
212: AND assembly_item_id is null
213: AND department_id is null
214: AND wip_entity_pattern is null
215: AND wip_matl_txn_type is null

Line 229: -- Standard Start of API savepoint

225: TaskID NUMBER := NULL;
226:
227: BEGIN
228: --
229: -- Standard Start of API savepoint
230: --
231: SAVEPOINT copy_rules;
232:
233: X_Count1 := 0;

Line 268: AND nvl(standard_operation_id , -1) = nvl(DSrcRec.Standard_Operation_ID , -1)

264: AND nvl(category_id , -1) = nvl(DSrcRec.Category_ID , -1)
265: AND nvl(subinventory_code , '***') = nvl(DSrcRec.Subinventory_Code , '***')
266: AND nvl(po_header_id , -1) = nvl(DSrcRec.PO_Header_ID , -1)
267: AND nvl(procure_flag , '*') = nvl(DSrcRec.Procure_Flag , '*')
268: AND nvl(standard_operation_id , -1) = nvl(DSrcRec.Standard_Operation_ID , -1)
269: AND nvl(department_id , -1) = nvl(DSrcRec.Department_ID , -1)
270: AND nvl(assembly_item_id , -1) = nvl(DSrcRec.Assembly_Item_ID , -1)
271: AND nvl(wip_entity_pattern , '*') = nvl(DSrcRec.WIP_Entity_Pattern , '*')
272: AND nvl(wip_matl_txn_type , '*') = nvl(DSrcRec.WIP_Matl_Txn_Type , '*');

Line 299: , standard_operation_id

295: , category_id
296: , po_header_id
297: , subinventory_code
298: , procure_flag
299: , standard_operation_id
300: , assembly_item_id
301: , department_id
302: , wip_entity_pattern
303: , wip_matl_txn_type

Line 336: , DSrcRec.Standard_Operation_ID

332: , DSrcRec.Category_ID
333: , DSrcRec.PO_Header_ID
334: , DSrcRec.Subinventory_Code
335: , DSrcRec.Procure_Flag
336: , DSrcRec.Standard_Operation_ID
337: , DSrcRec.Assembly_Item_ID
338: , DSrcRec.Department_ID
339: , DSrcRec.WIP_Entity_Pattern
340: , DSrcRec.WIP_Matl_Txn_Type

Line 371: AND nvl(standard_operation_id , -1) = nvl(DSrcRec.Standard_Operation_ID , -1)

367: AND nvl(category_id , -1) = nvl(DSrcRec.Category_ID , -1)
368: AND nvl(subinventory_code , '***') = nvl(DSrcRec.Subinventory_Code , '***')
369: AND nvl(po_header_id , -1) = nvl(DSrcRec.PO_Header_ID , -1)
370: AND nvl(procure_flag , '*') = nvl(DSrcRec.Procure_Flag , '*')
371: AND nvl(standard_operation_id , -1) = nvl(DSrcRec.Standard_Operation_ID , -1)
372: AND nvl(department_id , -1) = nvl(DSrcRec.Department_ID , -1)
373: AND nvl(assembly_item_id , -1) = nvl(DSrcRec.Assembly_Item_ID , -1)
374: AND nvl(wip_entity_pattern , '*') = nvl(DSrcRec.WIP_Entity_Pattern , '*')
375: AND nvl(wip_matl_txn_type , '*') = nvl(DSrcRec.WIP_Matl_Txn_Type , '*')

Line 426: AND nvl(standard_operation_id , -1) = nvl(SrcRec.Standard_Operation_ID , -1)

422: AND nvl(category_id , -1) = nvl(SrcRec.Category_ID , -1)
423: AND nvl(subinventory_code , '***') = nvl(SrcRec.Subinventory_Code , '***')
424: AND nvl(po_header_id , -1) = nvl(SrcRec.PO_Header_ID , -1)
425: AND nvl(procure_flag , '*') = nvl(SrcRec.Procure_Flag , '*')
426: AND nvl(standard_operation_id , -1) = nvl(SrcRec.Standard_Operation_ID , -1)
427: AND nvl(department_id , -1) = nvl(SrcRec.Department_ID , -1)
428: AND nvl(assembly_item_id , -1) = nvl(SrcRec.Assembly_Item_ID , -1)
429: AND nvl(wip_entity_pattern , '*') = nvl(SrcRec.WIP_Entity_Pattern , '*')
430: AND nvl(wip_matl_txn_type , '*') = nvl(SrcRec.WIP_Matl_Txn_Type , '*');

Line 457: , standard_operation_id

453: , category_id
454: , po_header_id
455: , subinventory_code
456: , procure_flag
457: , standard_operation_id
458: , assembly_item_id
459: , department_id
460: , wip_entity_pattern
461: , wip_matl_txn_type

Line 494: , SrcRec.Standard_Operation_ID

490: , SrcRec.Category_ID
491: , SrcRec.PO_Header_ID
492: , SrcRec.Subinventory_Code
493: , SrcRec.Procure_Flag
494: , SrcRec.Standard_Operation_ID
495: , SrcRec.Assembly_Item_ID
496: , SrcRec.Department_ID
497: , SrcRec.WIP_Entity_Pattern
498: , SrcRec.WIP_Matl_Txn_Type

Line 529: AND nvl(standard_operation_id , -1) = nvl(SrcRec.Standard_Operation_ID , -1)

525: AND nvl(category_id , -1) = nvl(SrcRec.Category_ID , -1)
526: AND nvl(subinventory_code , '***') = nvl(SrcRec.Subinventory_Code , '***')
527: AND nvl(po_header_id , -1) = nvl(SrcRec.PO_Header_ID , -1)
528: AND nvl(procure_flag , '*') = nvl(SrcRec.Procure_Flag , '*')
529: AND nvl(standard_operation_id , -1) = nvl(SrcRec.Standard_Operation_ID , -1)
530: AND nvl(department_id , -1) = nvl(SrcRec.Department_ID , -1)
531: AND nvl(assembly_item_id , -1) = nvl(SrcRec.Assembly_Item_ID , -1)
532: AND nvl(wip_entity_pattern , '*') = nvl(SrcRec.WIP_Entity_Pattern , '*')
533: AND nvl(wip_matl_txn_type , '*') = nvl(SrcRec.WIP_Matl_Txn_Type , '*')