DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 591: FROM AHL_MR_RELATIONSHIPS_APP_V A

587: ATTRIBUTE12,
588: ATTRIBUTE13,
589: ATTRIBUTE14,
590: ATTRIBUTE15
591: FROM AHL_MR_RELATIONSHIPS_APP_V A
592: WHERE (MR_HEADER_ID=P_SOURCE_MR_HEADER_ID or RELATED_MR_HEADER_ID=P_SOURCE_MR_HEADER_ID)
593: AND EXISTS(SELECT MR_HEADER_ID
594: FROM AHL_MR_HEADERS_APP_V
595: WHERE ( MR_HEADER_ID=A.MR_HEADER_ID

Line 1355: INSERT INTO AHL_MR_RELATIONSHIPS(

1351: l_rel_rec.mr_header_id :=l_mr_relation_Rec.MR_HEADER_ID;
1352: l_rel_rec.related_mr_header_id :=x_new_mr_header_id;
1353: END IF;
1354:
1355: INSERT INTO AHL_MR_RELATIONSHIPS(
1356: MR_RELATIONSHIP_ID,
1357: OBJECT_VERSION_NUMBER,
1358: LAST_UPDATE_DATE,
1359: LAST_UPDATED_BY,

Line 1383: AHL_MR_RELATIONSHIPS_S.NEXTVAL,

1379: ATTRIBUTE13,
1380: ATTRIBUTE14,
1381: ATTRIBUTE15)
1382: values(
1383: AHL_MR_RELATIONSHIPS_S.NEXTVAL,
1384: 1,
1385: SYSDATE,
1386: fnd_global.user_id,
1387: SYSDATE,