[Home] [Help]
87: | "effective" status should be treated as inserts |
88: | |
89: | * Updated within an "effective" status should ignore |
90: | the status and pass the other changed values to the |
91: | mrp_relief_interface table |
92: | |
93: +------------------------------------------------------------*/
94:
95: /* NOTE - changes within a "non-effective" status have already been
164:
165: END IF;
166:
167: /* MPS relief for assembly */
168: INSERT INTO mrp_relief_interface
169: (inventory_item_id, -- NN
170: organization_id, -- NN
171: last_update_date, -- NN sysdate
172: last_updated_by, -- NN :new.last_updated_by
223: 2,
224: 'WIP',
225: null,
226: null,
227: mrp_relief_interface_s.nextval,
228: new_project_id,
229: old_project_id,
230: new_task_id,
231: old_task_id
235: components, except for Deletion case. Here keeping
236: new_date as SYSDATE as before */
237: IF DELETING THEN
238: /* MPS relief for phantom components */
239: INSERT INTO mrp_relief_interface
240: (inventory_item_id, -- NN
241: organization_id, -- NN
242: last_update_date, -- NN sysdate
243: last_updated_by, -- NN :new.last_updated_by
294: 2,
295: 'WIP',
296: null,
297: null,
298: mrp_relief_interface_s.nextval,
299: new_project_id,
300: old_project_id,
301: new_task_id,
302: old_task_id
304: WHERE wip_entity_id = wip_enty_id
305: AND organization_id = org_id
306: AND wip_supply_type = 6;
307: ELSE /** INSERTING or UPDATING **/
308: INSERT INTO mrp_relief_interface
309: (inventory_item_id, -- NN
310: organization_id, -- NN
311: last_update_date, -- NN sysdate
312: last_updated_by, -- NN :new.last_updated_by
363: 2,
364: 'WIP',
365: null,
366: null,
367: mrp_relief_interface_s.nextval,
368: new_project_id,
369: old_project_id,
370: new_task_id,
371: old_task_id
472: | "Open" status should be treated as inserts |
473: | |
474: | * Updated within an "Open" status should ignore |
475: | the status and pass the other changed values to the |
476: | mrp_relief_interface table |
477: | |
478: +------------------------------------------------------------*/
479:
480: /* NOTE - changes within a "Closed" status have already been
548: --commented in bug#2289820 END IF;
549:
550: END IF;
551:
552: /* Now insert a record into MRP_RELIEF_INTERFACE to take care of
553: MPS relief for assembly Note that if bill designator changes
554: we do not insert a row for the assembly. */
555:
556:
553: MPS relief for assembly Note that if bill designator changes
554: we do not insert a row for the assembly. */
555:
556:
557: INSERT INTO mrp_relief_interface
558: (inventory_item_id, -- NN
559: organization_id, -- NN
560: last_update_date, -- NN sysdate
561: last_updated_by, -- NN :new.last_updated_by
612: 2,
613: 'WIP',
614: null,
615: null,
616: mrp_relief_interface_s.nextval,
617: new_project_id,
618: old_project_id,
619: new_task_id,
620: old_task_id
624:
625: /* insert any rows for phantom items */
626:
627: INSERT
628: INTO mrp_relief_interface
629: (inventory_item_id,
630: organization_id,
631: last_update_date,
632: last_updated_by,
685: 2,
686: 'WIP',
687: null,
688: null,
689: mrp_relief_interface_s.nextval,
690: new_project_id,
691: old_project_id,
692: new_task_id,
693: old_task_id
722:
723: /* inserts for the new bill designator */
724:
725: INSERT
726: INTO mrp_relief_interface
727: (inventory_item_id,
728: organization_id,
729: last_update_date,
730: last_updated_by,
782: 2,
783: 'WIP',
784: null,
785: null,
786: mrp_relief_interface_s.nextval,
787: new_project_id,
788: old_project_id,
789: new_task_id,
790: old_task_id
808:
809: /* now insert for the old bill designator */
810:
811: INSERT
812: INTO mrp_relief_interface
813: (inventory_item_id,
814: organization_id,
815: last_update_date,
816: last_updated_by,
869: 2,
870: 'WIP',
871: null,
872: null,
873: mrp_relief_interface_s.nextval,
874: new_project_id,
875: old_project_id,
876: new_task_id,
877: old_task_id