[Home] [Help]
21: end ;
22:
23:
24: select 1 into x_success
25: from mtl_transactions_interface mti
26: where rowid = p_rowid
27: and exists (
28: select 1
29: from mtl_system_items msi
49: begin
50:
51:
52: select 1 into x_success
53: from mtl_transactions_interface mti
54: where mti.rowid = p_rowid
55: and mti.accounting_class is not null
56: and ( ( mti.source_project_id is null
57: and exists (
108: into x_item_id,
109: x_org_id,
110: x_rev,
111: x_bom_rev
112: from mtl_transactions_interface
113: where rowid = p_rowid ;
114:
115: exception
116: when no_data_found then
147: cleaned up for R12
148: **********************************************/
149:
150: select 1 into x_success
151: from mtl_transactions_interface mti,
152: mtl_system_items msi
153: where mti.rowid = p_rowid
154: and msi.inventory_item_id = mti.inventory_item_id
155: and msi.organization_id = mti.organization_id
176:
177: if (x_bom_rev_exists in (1, 0) ) and (x_success = 1 ) then
178:
179: select 1 into x_success
180: from mtl_transactions_interface mti,
181: mtl_system_items msi
182: where mti.rowid = p_rowid
183: and msi.inventory_item_id = mti.inventory_item_id
184: and msi.organization_id = mti.organization_id
247: transaction_date
248: into x_item_id,
249: x_org_id,
250: x_txn_date
251: from mtl_transactions_interface
252: where rowid = p_rowid ;
253:
254: exception
255: when no_data_found then
265:
266: if ( x_rtg_exists >=0 ) then
267:
268: select 1 into x_success
269: from mtl_transactions_interface mti,
270: mtl_system_items msi
271: where mti.rowid = p_rowid
272: and msi.inventory_item_id = mti.inventory_item_id
273: and msi.organization_id = mti.organization_id
327: into x_bom_rev,
328: x_bom_rev_date,
329: x_org_id,
330: x_item_id
331: from mtl_transactions_interface
332: where rowid = p_rowid ;
333:
334:
335: exception
408: x_rtg_rev_date,
409: x_org_id,
410: x_item_id,
411: x_txn_date
412: from mtl_transactions_interface
413: where rowid = p_rowid ;
414:
415:
416: exception
475: begin
476:
477: /* we look at only manufacturing bill */
478: select 1 into x_success
479: from mtl_transactions_interface mti
480: where rowid = p_rowid
481: and ( (alternate_bom_designator is null)
482: or (alternate_bom_designator is not null
483: and exists (
502: x_success number := 0;
503: begin
504: /* we look at only manufacturing routing */
505: select 1 into x_success
506: from mtl_transactions_interface mti
507: where rowid = p_rowid
508: and ( (alternate_routing_designator is null)
509: or (alternate_routing_designator is not null
510: and exists (
539: *******************************************************/
540:
541: SELECT subinventory_code, transaction_action_id -- CFM Scrap Section
542: INTO x_subinv_code, x_txn_action
543: FROM mtl_transactions_interface mti
544: WHERE ROWID = p_rowid;
545:
546: IF x_txn_action = 30 THEN
547: IF x_subinv_code IS NULL THEN
552: END IF; -- CFM Scrap Section End
553:
554:
555: select 1 into x_success
556: from mtl_transactions_interface mti
557: where rowid = p_rowid
558: and subinventory_code is not null
559: and exists (
560: (
618:
619:
620: SELECT locator_id, transaction_action_id -- CFM Scrap Section
621: INTO x_loc_id, x_txn_action
622: FROM mtl_transactions_interface mti
623: WHERE ROWID = p_rowid;
624:
625: IF x_txn_action = 30 THEN
626: IF x_loc_id IS NULL THEN
630: END IF;
631: END IF; -- CFM Scrap Section End
632:
633: select 1 into x_success
634: from mtl_transactions_interface mti
635: where mti.rowid = p_rowid
636: and mti.subinventory_code is not null
637: and ( ( mti.locator_id is not null
638: and exists
654: );
655:
656:
657: select count(*) into x_proj_ref_exists
658: from mtl_transactions_interface mti
659: where mti.rowid = p_rowid
660: and source_project_id is not null ;
661:
662: if (x_proj_ref_exists = 1 ) then
661:
662: if (x_proj_ref_exists = 1 ) then
663:
664: select 1 into x_success
665: from mtl_transactions_interface mti,
666: mtl_item_locations mil
667: where mti.rowid = p_rowid
668: and ( ( mti.locator_id is not null
669: and mil.inventory_location_id = mti.locator_id
716: begin
717:
718:
719: select 1 into x_success
720: from mtl_transactions_interface mti
721: where rowid = p_rowid
722: and ( ( demand_class is not null
723: and exists
724: (
755: requirement
756: ************************************************/
757:
758: select 1 into x_success
759: from mtl_transactions_interface mti
760: where rowid = p_rowid
761: and ( ( schedule_group is not null
762: and exists
763: ( select 1
802: x_wip_entity_id,
803: x_organization_id,
804: x_line_id,
805: x_schedule_group_id
806: FROM mtl_transactions_interface mti
807: WHERE rowid = p_rowid;
808:
809: IF WIP_Validate.build_sequence(p_build_sequence => x_build_sequence,
810: p_wip_entity_id => x_wip_entity_id,
831: x_success number := 0;
832: begin
833:
834: select 1 into x_success
835: from mtl_transactions_interface mti
836: where rowid = p_rowid
837: and ( ( repetitive_line_id is not null
838: and exists
839: (
863: l_org_id number;
864: begin
865: -- fix MOAC, set id so project view works
866: select organization_id into l_org_id
867: from mtl_transactions_interface
868: where rowid = p_rowid;
869: fnd_profile.put('MFG_ORGANIZATION_ID', l_org_id);
870:
871: /*******************************************************
875: is done in inltev.ppc.
876: *********************************************************/
877:
878: select 1 into x_success
879: from mtl_transactions_interface mti
880: where rowid = p_rowid
881: and ( ( source_project_id is not null
882: and exists (
883: select 1
935: end if;
936: ***************************************************/
937:
938: select 1 into x_success
939: from mtl_transactions_interface mti,
940: mtl_parameters mps
941: where mti.rowid = p_rowid
942: and mps.organization_id = mti.organization_id
943: and ( ( nvl(mps.project_control_level,1) = 2
1001: ***************************************************/
1002:
1003:
1004: select 1 into x_success
1005: from mtl_transactions_interface mti
1006: where mti.rowid = p_rowid
1007: and((mti.scheduled_flag <> 1
1008: and not exists(
1009: select 'exists'
1056: begin
1057:
1058:
1059: select 1 into x_success
1060: from mtl_transactions_interface mti
1061: where rowid = p_rowid
1062: and mti.scheduled_flag in (
1063: select lookup_code
1064: from mfg_lookups
1093: begin
1094:
1095: SELECT 1
1096: INTO x_success
1097: FROM mtl_transactions_interface mti
1098: WHERE rowid = p_rowid
1099: AND ((end_item_unit_number IS NULL
1100: AND (pjm_unit_eff.enabled = 'N'
1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))