[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
175:
176: if (x_bom_rev_exists in (1, 0) ) then
177:
178: select 1 into x_success
179: from mtl_transactions_interface mti,
180: mtl_system_items msi
181: where mti.rowid = p_rowid
182: and msi.inventory_item_id = mti.inventory_item_id
183: and msi.organization_id = mti.organization_id
246: transaction_date
247: into x_item_id,
248: x_org_id,
249: x_txn_date
250: from mtl_transactions_interface
251: where rowid = p_rowid ;
252:
253: exception
254: when no_data_found then
264:
265: if ( x_rtg_exists >=0 ) then
266:
267: select 1 into x_success
268: from mtl_transactions_interface mti,
269: mtl_system_items msi
270: where mti.rowid = p_rowid
271: and msi.inventory_item_id = mti.inventory_item_id
272: and msi.organization_id = mti.organization_id
326: into x_bom_rev,
327: x_bom_rev_date,
328: x_org_id,
329: x_item_id
330: from mtl_transactions_interface
331: where rowid = p_rowid ;
332:
333:
334: exception
407: x_rtg_rev_date,
408: x_org_id,
409: x_item_id,
410: x_txn_date
411: from mtl_transactions_interface
412: where rowid = p_rowid ;
413:
414:
415: exception
474: begin
475:
476: /* we look at only manufacturing bill */
477: select 1 into x_success
478: from mtl_transactions_interface mti
479: where rowid = p_rowid
480: and ( (alternate_bom_designator is null)
481: or (alternate_bom_designator is not null
482: 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 (
540: *******************************************************/
541:
542: SELECT subinventory_code, transaction_action_id -- CFM Scrap Section
543: INTO x_subinv_code, x_txn_action
544: FROM mtl_transactions_interface mti
545: WHERE ROWID = p_rowid;
546:
547: IF x_txn_action = 30 THEN
548: IF x_subinv_code IS NULL THEN
553: END IF; -- CFM Scrap Section End
554:
555:
556: select 1 into x_success
557: from mtl_transactions_interface mti
558: where rowid = p_rowid
559: and subinventory_code is not null
560: and exists (
561: (
619:
620:
621: SELECT locator_id, transaction_action_id -- CFM Scrap Section
622: INTO x_loc_id, x_txn_action
623: FROM mtl_transactions_interface mti
624: WHERE ROWID = p_rowid;
625:
626: IF x_txn_action = 30 THEN
627: IF x_loc_id IS NULL THEN
631: END IF;
632: END IF; -- CFM Scrap Section End
633:
634: select 1 into x_success
635: from mtl_transactions_interface mti
636: where mti.rowid = p_rowid
637: and mti.subinventory_code is not null
638: and ( ( mti.locator_id is not null
639: and exists
655: );
656:
657:
658: select count(*) into x_proj_ref_exists
659: from mtl_transactions_interface mti
660: where mti.rowid = p_rowid
661: and source_project_id is not null ;
662:
663: if (x_proj_ref_exists = 1 ) then
662:
663: if (x_proj_ref_exists = 1 ) then
664:
665: select 1 into x_success
666: from mtl_transactions_interface mti,
667: mtl_item_locations mil
668: where mti.rowid = p_rowid
669: and ( ( mti.locator_id is not null
670: and mil.inventory_location_id = mti.locator_id
717: begin
718:
719:
720: select 1 into x_success
721: from mtl_transactions_interface mti
722: where rowid = p_rowid
723: and ( ( demand_class is not null
724: and exists
725: (
756: requirement
757: ************************************************/
758:
759: select 1 into x_success
760: from mtl_transactions_interface mti
761: where rowid = p_rowid
762: and ( ( schedule_group is not null
763: and exists
764: ( select 1
803: x_wip_entity_id,
804: x_organization_id,
805: x_line_id,
806: x_schedule_group_id
807: FROM mtl_transactions_interface mti
808: WHERE rowid = p_rowid;
809:
810: IF WIP_Validate.build_sequence(p_build_sequence => x_build_sequence,
811: p_wip_entity_id => x_wip_entity_id,
832: x_success number := 0;
833: begin
834:
835: select 1 into x_success
836: from mtl_transactions_interface mti
837: where rowid = p_rowid
838: and ( ( repetitive_line_id is not null
839: and exists
840: (
864: l_org_id number;
865: begin
866: -- fix MOAC, set id so project view works
867: select organization_id into l_org_id
868: from mtl_transactions_interface
869: where rowid = p_rowid;
870: fnd_profile.put('MFG_ORGANIZATION_ID', l_org_id);
871:
872: /*******************************************************
876: is done in inltev.ppc.
877: *********************************************************/
878:
879: select 1 into x_success
880: from mtl_transactions_interface mti
881: where rowid = p_rowid
882: and ( ( source_project_id is not null
883: and exists (
884: select 1
936: end if;
937: ***************************************************/
938:
939: select 1 into x_success
940: from mtl_transactions_interface mti,
941: mtl_parameters mps
942: where mti.rowid = p_rowid
943: and mps.organization_id = mti.organization_id
944: and ( ( nvl(mps.project_control_level,1) = 2
1002: ***************************************************/
1003:
1004:
1005: select 1 into x_success
1006: from mtl_transactions_interface mti
1007: where mti.rowid = p_rowid
1008: and((mti.scheduled_flag <> 1
1009: and not exists(
1010: select 'exists'
1057: begin
1058:
1059:
1060: select 1 into x_success
1061: from mtl_transactions_interface mti
1062: where rowid = p_rowid
1063: and mti.scheduled_flag in (
1064: select lookup_code
1065: from mfg_lookups
1094: begin
1095:
1096: SELECT 1
1097: INTO x_success
1098: FROM mtl_transactions_interface mti
1099: WHERE rowid = p_rowid
1100: AND ((end_item_unit_number IS NULL
1101: AND (pjm_unit_eff.enabled = 'N'
1102: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))