DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 541: FROM AHL_MR_RELATIONSHIPS_APP_V A

537: ATTRIBUTE12,
538: ATTRIBUTE13,
539: ATTRIBUTE14,
540: ATTRIBUTE15
541: FROM AHL_MR_RELATIONSHIPS_APP_V A
542: WHERE (MR_HEADER_ID=P_SOURCE_MR_HEADER_ID or RELATED_MR_HEADER_ID=P_SOURCE_MR_HEADER_ID)
543: AND EXISTS(SELECT MR_HEADER_ID
544: FROM AHL_MR_HEADERS_APP_V
545: WHERE ( MR_HEADER_ID=A.MR_HEADER_ID

Line 1117: INSERT INTO AHL_MR_RELATIONSHIPS(

1113: l_rel_rec.mr_header_id :=l_mr_relation_Rec.MR_HEADER_ID;
1114: l_rel_rec.related_mr_header_id :=x_new_mr_header_id;
1115: END IF;
1116:
1117: INSERT INTO AHL_MR_RELATIONSHIPS(
1118: MR_RELATIONSHIP_ID,
1119: OBJECT_VERSION_NUMBER,
1120: LAST_UPDATE_DATE,
1121: LAST_UPDATED_BY,

Line 1145: AHL_MR_RELATIONSHIPS_S.NEXTVAL,

1141: ATTRIBUTE13,
1142: ATTRIBUTE14,
1143: ATTRIBUTE15)
1144: values(
1145: AHL_MR_RELATIONSHIPS_S.NEXTVAL,
1146: 1,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,